11. Display the client number and name and the client number
and name of the person who referred that client.
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between a vector and an Array? (Java)
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>>>>
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
why pl sql doesn't support retrieving multiple records
What is RULE-based approach to optimization ?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
what is the difference between substr and instr function in oracle?
How to define a specific record type?
How to turn on or off recycle bin for the session?