Questions

Hi Tom.I have very old application. Then I saw some store procedure using (+) or (-) notation on the query. What i want to ask are :1. what is the difference between (+) and (-) notation ?2. what is the difference between (the position of the notation I put on...

Dear Team,I have a logging table with the following structure:<code>SQL> desc t Name Null? Type ----------------------------------------------------- -------- ------------------------------------ LOG_ID ...

Hello.I have a quick question about Oracle 11g SQL command.I need to get only HH24:MI:SS data from SYSDATE;for example, select TO_DATE(SYSDATE, 'HH24:MI:SS') from dual;I tried it then error is like below.ORA-01861: literal does not match format string01861. 00...

Consider the following two tables and their primary keys:<code>create table testuser.test1 ( col1 number not null, col2 number not null, col3 number not null);alter table testuser.test1 add constraint test1_pk primary key (col1);create table testus...

I have created application root container and two applicatioon PDBs. In application root created a table products ar follows:<code>CREATE TABLE products SHARING=EXTENDED DATA (prod_id NUMBER(4) CONSTRAINT pk_products PRIMARY KEY, prod_name VARCHAR2(15));ALTER ...

I am executing a sql-plus session to dump a table's data into a .csv file. I need header details along with the data in the dumped csv file. When I use the "set heading on" option, I am getting header details along with the data plus one empty line at the star...

I find myself needing to generate a data set where I get the average number of rows over a time period. This period needs to be daily, by hour, for the same period for previous days. As an example, get the average number records from 1 am – 2 am for the last 1...

Team,Given this JSON, how do i increment the quantity by two in each level?tried the below using json_transform but ended up with error.is that possible using json_transform function? kinldy help.<code>demo@XEPDB1> select json_serialize(y pretty) y 2 from t ...

While we are working on dbms_cloud API in ATP DB, we are facing some issues. When we are calling the API directly from SQL Developer, it works perfectly fine and data is getting loaded into the tables.<code>BEGIN dbms_output.put_line('Start Time : '||TO_CHAR(...

Scenario->We took Full export of Oracle database on date 10th--> then created few new tables on date 11th--> then ran FULL restore using export backup on 10th--> somehow, the tables created after 10th did not drop and still showing in database. However, the da...

Dear Friends,I have export/dmp file created through SYSTEM schema. Now I want to import this dmp file into a freshly installed oracle.Version of both Oracle is 10g. I tried it but its giving some errors.My export command is exp userid=SYSTEM/MANAGER file=DAIL...

Hello,We have created 5 new tables ( Table_A - around 80K records, Table_B- around 15K records, Table_C - around 35K records, Table_D- around 55K records, and Table_E- around 130K records)These tables have been used in a view using a UNION ( The view had anoth...

i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "<b>ORA-12560: TNS:protocol adapter error</b> " what should i do?please help.. ...

Hi Tom,1 ) As per my understanding, Log-File-Sync wait is the duration, after which I receive an acknowledgement that my commit is successful. In my database the only prominent issue I see is huge log-file-sync waits.2 ) There are 32 cpu and each one is 8 core...

Hi Tom,Can you please help me in the below issue Please?I have code that is causing an issue during run time,but i dont know how to write exception handling for the same.Ex. There is a view(v1) on a table and another view(v2) in which has some business logic.T...

Hi Tom / Experts,I have a test table with following schema<code>BLOG_DOCS----------doc_id number PRIMARY KEYdoc_title varchar2(25) NOT NULLdoc_author varchar2(25) NOT NULLdoc_data CLOB NOT NULL</code>There is an oracle text index created on blog_data as follow...

Table 8-1 (https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/vldb-and-partitioning-guide.pdf#page=353&zoom=100,0,120) of the VLDB and Partition Guid (19c) lists cell ("Insert", "Issued on Parent") as "(Not applicable)". Why is it "not applic...

I have a procedure that inserts in to a table testprocedure insert_data asbegininsert into test values ('test;');end;Function get_data return number asbegininsert_data;return 1;end;When I call the function in the select statement asselect get_data from dual;I ...

May I ask about the "java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver".Per Java document, the PATH and CLASSPATH shall be configured in the Windows 10 environment variables .Below are information regarding the system/database version and what...

Hello,I have a table with BLOBs and they are actually character logs generated by fax transmission software. They are about 4k-16k big and pretty redundant, they compress with zlib to just about 1k-2k. And I want to store them compressed in DB. Now question wh...