When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 17800Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;
7 12918SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10123wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
6 15831Post New Accenture SQL PLSQL Interview Questions
What is the effect of high alkaline water to a boiler?
Define about obj-open method?
what is swap deployments?
What is s token?
Explain what is pulse logic system?
What is the basic structure of a sas program?
Rate yourself on a scale of 1 to 5 on your ability to work under pressure where 1 is the least and 5 is the maximum?
Iam preparing for Visakhapatnam Management Trainee 2009 entrance exam.. If anybody have Visakhapatnam Management Trainee Interview questions Pls forward to my mail id srikanth.avanthi@gmail.com .. It is kindly request..
What is namespace in .net?
why do you want to work with aspiring minds?
What are bootstrap media objects?
How do I remove a table in word but keep the text?
Is it possible to host wordpress using amazon web services?
Why we use the openxml clause?
What is the use of the function htmlentities?