Skip to Main Content

Questions

QuestionUpdatedAsked

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...
4 hours ago5.9 years ago

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

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...
35 hours ago6.2 years ago

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...
35 hours ago5.8 years ago

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 ...
35 hours ago1.4 years ago

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...
35 hours ago13 days ago

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...
35 hours ago11 days ago

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 ...
3 days ago1.1 years ago

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(...
4 days ago13 days ago

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...
4 days ago12 days ago

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...
4 days ago11 days ago

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...
4 days ago2 weeks ago

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.. ...
4 days ago15.2 years ago

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...
4 days ago7.2 years ago

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...
7 days ago2 weeks ago

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...
7 days ago4 weeks ago

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...
8 days ago13 days ago

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 ...
8 days ago16.3 years ago

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...
8 days ago1.6 years ago

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...
8 days ago19.1 years ago