bst365体育投注网址大全

Questions tagged [oracle]

bst365体育投注网址大全 Oracle Database is a Multi-Model Database Management System created by Oracle Corporation. Do NOT use this tag for other products owned by Oracle, such as Java and MySQL.

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

ORA-12170: TNS:Connect timeout occurred 12170. 00000 - “TNS:Connect timeout occurred”

I created a database link between two database one in my real machine and the second in my virtual machine using virtualbox CREATE PUBLIC DATABASE LINK LINK34 connect to user2 identified by user2 ...
-1
votes
0answers
6 views

The database script from the site is displayed in the search engines instead of the necessary information

The database script from the site is displayed in the search engines (like Google and etc.) instead of the necessary information. What could be the problem? Unfortunately I cannot provide neither web ...
0
votes
0answers
14 views

PLS-00103: Encountered the symbol “ON” when expecting one of the following

Please note: I have tried other Stack overflow questions, but none solve my problem... I am getting this error: PLS-00103: Encountered the symbol "ON" when expecting one of the following ...
0
votes
1answer
8 views

Sort data with a particular text last in oracle

I am trying to sort the below varchar field in oracle. Source: Not a Valid Version Not a Valid Version 3.12p5s2 I will always have one value like '3.12p5s2' and other values with the text 'Not a ...
0
votes
1answer
16 views

oracle unlock HR account

hello i'm learning oracle and trying to unlock HR account here's what happend to me No rows Selected why ? enter image description here
0
votes
1answer
29 views

oracle SQL Concatenate 2 columns based on condition

let's say i have a table : +----+------------+------------+ | ID | NAME1 | NAME2 | +----+------------+------------+ | A1 | DAVE | DAN | | A1 | DOR | MON | | A2 | ...
0
votes
2answers
29 views

SQL- Math with Dates

I am working out of Oracle SQL. I have some dates that may have been poorly formatted when loading. I'm doing a basic Max(date)-Min(Date) to get the difference in days. My results are: +000000156 00:...
0
votes
0answers
20 views

Improving query performance to search in clob column in big table

I have a big table (about 4.6 million records) with many columns, I have concatenated some columns and inserted it in clob column(one column have an alias of the name so the name came in a different ...
0
votes
1answer
24 views

(Oracle)Getting 25th number using interpolating

My goal is to get 25th number. For instance I have 4 row, such as 3,4,5 and 7. My goal is to get 1.25th(=(4+1)0.25). Expected result is 3.25 which is obtained by interpolating(3+0.25(4-3)). I have ...
0
votes
1answer
13 views

Unable to connect to Oracle DB by Tableau from windows10

I have installed tableau desktop version 2020.1.3 (with its license) and also its required drivers from here. Now, according to what is considered in installation guides, what I am supposed to do as ...
0
votes
1answer
24 views

Convert CST to UTC at the time of the Daylight Savings start and end in Oracle Sql

I am trying to convert a timestamp from localtimezone (CST) to UTC in Oracle SQL. I tried few SQL statements: SELECT CAST('08-MAR-2020 02.05.02.575000000 AM' AS TIMESTAMP WITH TIME ZONE ) AT TIME ...
0
votes
1answer
49 views

SQL Table errors [closed]

I am a college student taking a Database course. Currently making tables for Apex Oracle and just cannot seem to understand how to solve these errors. Appreciate any feedback. Below is my code. CREATE ...
0
votes
1answer
31 views

Avoid deadlock from for update

How to release the row level lock of another session to avoid dead lock from for update? I have a table [https://ibb.co/BLg50h5][1] Here is the code, DECLARE CURSOR c1 IS SELECT id FROM ...
0
votes
1answer
22 views

Oracle SQL: At time zone does not convert properly for timestamps before 1 June 1905

I need to convert timestamps stored in my database in UTC format to SGT format (UTC + 8) before my frontend service can consume it. The query i use is this: SELECT DATE_OF_PURCHASE at time zone 'Asia/...
0
votes
0answers
24 views

Querying larg table without extending tablespace in Oracle DB

I have a DB table (used for a queue) that is holding alot rows. Now I'm looking for the oldest entries to see when thes have been enqueued by running the query: SELECT * FROM DB_SCHEMA.WORKER ORDER BY ...

15 30 50 per page
1
2 3 4 5
8274