How to create DSN..Explain?2 17802
What are Clusters ?5 6169
what is difference between foreign key and reference key3 36460
what is unique key?14 17487
what is the difference between primary key & foreign key?57 105742
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 5777
structural difference between bitmap and btree index ?1 10297
how to retrieve daily sal from emp table in oracle 10g2 4468
which language is used to develop the oracle........?4 9581
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>>>>1 2542
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?1234
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)4 5116
how 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 2512
Is 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.280
Can developer modify the out-of-box workflows in sharepoint 2010?
What is a zed encoder? How does it work?
what are the differences of software life cycle models
What is the purpose of shortcut keys?
What is the difference between jms queue receiver and jms queue requestor?
Does mongodb support foreign key constraints?
What is bulk copy or bcp in oracle?
Find out the list of authorization objects which contains activity as a field? Thanks in advance.
What is css and what are its advantages?
Why is it better to wrap items in combobox item?
What are respectively some remarkable functions of insulin?
How do you cover the logic of asynchronous methods in test class?
What is apache scoreboard?
Can you lock more than one database at the same time in mongodb?
Can we receive the goods before the scheduled delivery date in scheduling agreement?