How to create DSN..Explain?2 16434
What are Clusters ?5 5514
what is difference between foreign key and reference key3 34737
what is unique key?14 16335
what is the difference between primary key & foreign key?57 102619
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 5402
structural difference between bitmap and btree index ?1 9882
how to retrieve daily sal from emp table in oracle 10g2 4132
which language is used to develop the oracle........?4 9110
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 2294
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?1077
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)4 4834
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 2258
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.140
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
sir what is the depreciation and how to calculate depreciation as per company books, i need as per IT ACT, AND Companies Act give me clarification with example
Explain the importance of cloud computing in IT?
What are the requirements of a good fuel?
What is transister define the transister ammiter ,base, colector.
What are CAPIs ?
Hi , Does anyone have advanced sas certification latest dumps(a00-212). please mail me to email@example.com Thank you sunny
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
who is first vice primeminister who is first prime minister when did first world war arise when did second world war arise
How would you finalize the number of resources/testers needed for the testing in the estimation ?
SAP SD. What are the Condition Conversion and Customer/Material conversion in the Organization Structure and should define and assign? Please nevigate and explain with example.
Customs Duty is fixed or Non Fixed
I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...
alternator make voltage 120 degree. as we change degree ex. 100 and 160 or other degree then voltage make. yes or no and why
How to findout raw or ups power? its not indicated in socket,