How to create DSN..Explain?2 16571
What are Clusters ?5 5579
what is difference between foreign key and reference key3 34909
what is unique key?14 16461
what is the difference between primary key & foreign key?57 102969
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 5452
structural difference between bitmap and btree index ?1 9930
how to retrieve daily sal from emp table in oracle 10g2 4170
which language is used to develop the oracle........?4 9165
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 2327
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?1101
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)4 4875
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 2285
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.159
if a number of plc s are there then how many modbus to be used
HOw to add the recovery file at runtime to the test file .
write a sql query retrive all xml data. how to retrive xml data wit single sql query.
How do you avoid the "Invalid use of null" error when reading null values from a database?
sir,please give me some exam paper for referance. Thanks & Regards,
why you done mba in finance
what is generics? can u explain 5 to 6 examples on generics that covers class,method,structure,list,delegates?
what is meaning of bus riser
What are the ITU-T (CCITT) Standards ?
what is a CopyCursor ?
All technical,written test questions
what is the advaantage of each user having its own copy of the shell?
What is Sobel gradient filters?
What is the working mechanism of OLTC in Power Transformers????