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 16081Dear 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 10189SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 8942wirte 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 13453Post New Accenture SQL PLSQL Interview Questions
Why do we use asp.net?
Explain about the commit method?
How can we identify a column in a database in uipath studio?
Please give an example of a situation where you had to make a difficult decision. What was the outcome?
How do I make a link popup a new window?
What is java listener?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
How can I install a new theme in drupal?
What is the apex trigger in salesforce? : salesforce integration
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
what does the use of group policy provide you as a network administrator? : Windows server 2008
Is arraylist a class?
How many kinds of operators do we have in python? Explain arithmetic operators?
What is the difference between core and contrib?
In between UPS out going changer over switch and ups raising main input, both side cable gland producing heat but the cable doesn't get heat,Why?