Questions tagged [oracle]
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.
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
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 ...
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 ...
I am trying to sort the below varchar field in oracle.
Not a Valid Version
Not a Valid Version
I will always have one value like '3.12p5s2' and other values with the text 'Not a ...
hello i'm learning oracle and trying to unlock HR account
here's what happend to me
No rows Selected
enter image description here
let's say i have a table :
| ID | NAME1 | NAME2 |
| A1 | DAVE | DAN |
| A1 | DOR | MON |
| A2 | ...
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:
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 ...
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 ...
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 ...
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 ...
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.
How to release the row level lock of another session to avoid dead lock from for update?
I have a table
Here is the code,
CURSOR c1 IS
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/...
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 ...