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 16155Dear 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 10327SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 9001wirte 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 13582Post New Accenture SQL PLSQL Interview Questions
How can I require that fields be filled in, or filled in correctly?
What is the biggest dam in america?
How can i do partition of my hard disk in preloaded windows 7 in my system
What is Selenium IDE?
What are statistical features of R?
tell something about your hobbies.
What is the difference between c++ and visual basic?
Define setup time?
What is inner text?
hi sir my name is srikanth plz send me question papers
Difference between class#getinstance() and new operator ?
How do I combine different chart types into my excel spreadsheet?
How might react handle or restrict props to certain types, or require certain props to exist?
In what ways do you stay informed about the latest advancements and research in agricultural engineering to continuously improve your skills and knowledge?
What is the host?