Which environment variables are absolutely critical in order
to run the OUI?
No Answer is Posted For this Question
Be the First to Post Answer
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is using clause and give example?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
SQL> 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>>>>
What would you use to improve performance on an insert statement that places millions of rows into that table?
What is oracle rownum?
how to find full database size
1 Answers BirlaSoft, Consultancy,
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
How to start instance with a minimal initialization parameter file?
What are the attributes that are found in a cursor?
What is an Index ? How it is implemented in Oracle Database ?
20. Using a set operator, display the client number of all clients who have never placed an order.