Skip to Main Content

Questions

QuestionUpdatedAsked

When having two simultaneous merges into a table with a unique constraint in different sessions, the second one throws ORA-00001.Steps to reproduce:<code>create table tab1 (col1 number);create unique index ind1 on tab1(col1);--1st session:merge into tab1 dusin...
2 days ago4 days ago

HiI use this table function for string split (a space is used as a separator)create or replace FUNCTION fmv_space_to_table(p_list IN VARCHAR2) RETURN fmv_test_type AS l_string VARCHAR2(32767) := p_list || ' '; l_comma_index PLS_INTEGE...
2 days ago3 days ago

create table hotel_reservation with following fields.Booking id,booking start datebooking end dateroom type,room rentwrite PL/SQL block to accept start and end booking date and display all hotel reservation between that date.*** In this question i am stuck in ...
2 days ago3 days ago

Hi,is there a method to set default system privileges for all new created objects in Oracle, such as tables, sequences, procedures and functions and triggers? For example, select privilege assigned to an Oracle user.How to make it possible without having to wr...
2 days ago4 days ago

Hello Team,I would like to know is there any provision for parallelly copying data from main table (one schema) to different schema table without hampering current traffic?We need such provision/approach which should be faster way of doing this.Please suggest ...
2 days ago4 days ago

hello sir,I want to see the blocking sessions that occur during the day to fix the sessions or SQLs that are causing the others to lock up. There is no trace of locker SQLs in the GV$ACTIVE_SESSION_HISTORY . The sql_id and top_level_sql_id fields specify the l...
2 days ago5 days ago

How can I convince my developers there is a better way to do this?SELECT MAX (weight) weight FROM client.pet_weight WHERE pet_id = :pet_id AND setup_date = (SELECT MAX (setup_date) ...
2 days ago19.5 years ago

Dear Tom,I have load testing on DR database now i have 4000 processes (show parameter processes), now i want to increase it on DR site and DR Database in Snapshot standby mode only. Doubts-1. Can you explain what is the use of processes in oracle like a single...
2 days ago7 years ago

<u></u>Dear Team,We have a delete statement that, when executed, runs for infinite time (we even tried to keep it running for more than 3 days and it was still running) until the we killed the session. We are struggling with support since more than a month and...
3 days ago5 months ago

Hi, How to compare the two tables in SQL developer same database which performs the following actions as add, delete, modify Where I can add delete or modify into source table to target table.Can I get example with procedure for the about task please help me o...
3 days ago4 months 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 ...
3 days ago1.4 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...
3 days ago7.2 years ago

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

Dear Team,I have a logging table with the following structure:<code>SQL> desc t Name Null? Type ----------------------------------------------------- -------- ------------------------------------ LOG_ID ...
5 days ago2 weeks 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...
5 days 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...
5 days ago5.8 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...
5 days ago2 weeks 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...
5 days ago2 weeks 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 ...
8 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(...
8 days ago2 weeks ago