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 17664Dear 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 12713SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10012wirte 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 15584Post New Accenture SQL PLSQL Interview Questions
What are the limitations of automating software testing?
How to find beam R/F cutting length
Give a brief about the django admin.
What is ms excel explain any four function used in ms excel?
what are the files that need to be included with applications using MSACCESS?
Tell me name of main configuration file of apache server?
What does the elements mean in syntax given for url in html?
Explain 3 tier architecture implementation while deploying qlikview application?
If we will ask you to sell some product will you do that?
Explain socket programming in perl?
In visual basic, I can set the color of a cell with the .interior.colorindex property. How can I read the color of a cell before I change it?
how to connect your project in database?
What are schema-level triggers?
What are the different cloud service models in cloud architecture?: cloud computing architecture
Why is arraylist used?