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 16565Dear 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 10898SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 9322wirte 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 14277Post New Accenture SQL PLSQL Interview Questions
How Secure SAP Hybris Is?
What is php artisan serve?
What is USB (Universal Serial Bus) ?
What is ETL?
Can you create a tabletype of recordset in Jet connected ODBC dbengine.
How do I open a pgadmin file in windows?
how to pass journal entries for reverse tax on input tax paid
What can damage hard drive?
How do I manually install a driver in windows 7?
What are identifiers c?
What is the role of process-modeling tools erp implementation?
What is network topology strategy?
How can we increase disk read performance in single command in Linux operating system?
In OB52 , How to define two open posting period, Like only 5 and 8 posting should be open.. should not open 6 and 7..period..
Where can I find excel on my computer?