How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
2 7174SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
1 3419What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
1773how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
1 3431Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
829Post New Infosys Oracle General Interview Questions
What is string literal in c#?
VSS performance is extremely slow?
What is a dipole moment?
How do you show hidden formulas in excel?
Explain the difference between service & intent service?
what is Batch Apex?
What kind of tools might you use in the build steps to optimize the compiled output of the react code?
Explain how big is ‘big data’?
We have studied about many techniques for finding the stability of system, ROOT LOCUS, ROUTH, BODE PLOT, POLER PLOT etc. In these which is used where. what are the difference among them... PLZ tell me.......
Where does the performance measure is included? a) Rational agent b) Task environment c) Actuators d) Sensor
The project charter: A. Includes a product description, describes the business need of the project, and is published by the project manager B. Includes a product description, describes the business need of the project, and is published by the project sponsor C. Includes the contract when the project is performed by a vendor and is published by a manager external to the project D. Includes a product description, describes the business need of the project, and is published by a manager external to the project
Why do you mean by word Insurance?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is bdoc in crm?
What is scala option?