Given a set of database records that record the date when an object enters a particular state, I would like to produce a query that shows how many objects are in each state on any particular date. ...

I just set default timestamp format as ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF' When I insert the data into the table the timestamp inserted as, 0014-08-11 04:45:24.000...

I am trying to Run setup.exe as part of Oracle 19c installation on windows 10. I have downloaded the zip file and extracted it in a folder inside C drive. When I try to run setup.exe by right click...

I am trying to write insert statements in Oracle and suddenly it stopped. I don't receive any error message, but the scriptRunner task won't stop running and I can't insert anything. I've cancell...

I have a table 'MSATTRIBUTE' with 3000K rows. I used the following query to retrieve data, this query has different execution plan with same DB data but in different env. in one env, it appears ful...

I need to connect to an ADW instance provisioned in my OCI space. The documentation to connect shows me how to connect using wallet credentials, but using sql developer. I am able to connect using ...

I have strings that look like {ABCDE}{F1} {GHIJ}{K12} I want to extract the text between the first curly brackets ABCDE GHIJ I tried searching online but a lot of answers seem to be using fun...

I get this Error everytime i try to connect to the Oracle DB: DPI-1047: Cannot locate a 64-bit Oracle Client library: "Error loading shared library libnsl.so.1: N o such file or directory (nee...

I try to read an Oracle BLOB field and show the content i a richTextBox. The examples i find with google are almost the same but still i can't get it to work. I know that the BLOB field contains se...

I have a date value (either valid date or invalid date) store in varchar format. Is it possible to check the date is valid or not in sql query.

I am trying to select from a table with the following structure : MATERIALS id shortname longname all the lines where the long name is like the short name. I've tried the solution presented h...

In Cassandra I am used to the USING TTL clause of upserts which sets a number of seconds after which the upserted data will be deleted. Does Oracle have a feature like this? I haven't been able to...

I would like rename scheduler job in Oracle, is it possible? dba_scheduler_jobs(owner = "db", name = "my_job") => dba_scheduler_jobs(owner = "db", name = "my_own_job"); Thanks for answers.

I am new to Oracle and for practice I have created some tables (customer, drivers, payment, booking, location, area, job, job_history) in Oracle 11g and upon select * from cat statement I have foun...

all I'm trying to connect to an Oracle 19C database. I have installed two Oracle Clients (11g and 12c) because we need to support legacy programs. I can connect with no issue with any user using sq...

I am working with Oracle 19c in centos 7. After Oracle installation, i created new Container Database(CDB) with Plugguble Database(PDB) using DBCA. I am working with port number=1522 [oracle@ol8-19...

I have a timestamp which I want to truncate. I am using the trunc funtion in oracle. This seems to do what I want however from the documentation it should only accept a date and not a timestamp se...

I have a Java Spring application with lots of queries, which so far have worked until spring boot 3.2.0. Recently, after simply changing to spring boot 3.2.1, I started getting this kind of error: ...

Let's say we have the table "letters" like so: a | b ----- 0 | 0 0 | 1 1 | 0 1 | 1 And the following select statement: SELECT val1, val2, x.a. val3 FROM table1, table2, (SELECT a FR...

Using Oracle 11.2 Hi, Here is what I want to do: I'm scheduling jobs using dbms_scheduler. The number of jobs to schedule is not fixed and a max of 4 jobs should run at the same time. The procedu...

String s1 = PasswordText4.getText(); String s2 = ConfirmText4.getText(); String s3 = NameText4.getText(); String s4 = UsernameText4.getText(); String s5 = jLabel16.getText(); if (PasswordTex...

Im using PL/SQL. I am trying to have a for loop right after I define my temporary tables in the with clause. However, Im getting an error to have a SELECT query first. For instance WITH TMP1 AS (...

I want to change character set of oracle database from 'WE8MSWIN1252' to 'AL32UTF8' I tried to execute following steps from the link (http://download.oracle.com/docs/cd/B10501_01/server.920/a96529...

we are implementing a unit test system of our database production object like package, procedure, trigger & co. To do so, we have a container which create a database from https://github.com/ora...

I have trouble understanding what happens in the oracle database after this sql is executed: CREATE TABLE EMPTYSTRING ( COLUMNA VARCHAR2(1) ); INSERT INTO EMPTYSTRING (COLUMNA) VALUES('X'); ALT...