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 17660Dear 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 12706SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10006wirte 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 15581Post New Accenture SQL PLSQL Interview Questions
What is angular 5?
How much ram do I have linux?
Whate are resource files?
i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)
write the steps to start tbsm?
What are what if analysis tools in excel?
What is Dynamic Binding and Dynamic Loss?
What is the criteria for LTQ (LC-MS/MS) SEQUEST search?
What is a modification assistant?
What is the purpose of @doublerangefieldvalidator?
What is return on shareholder s funds?
How many assistance classes can a webdynpro component have?
What is file and example?
What symbol is used for parameterization in cucumber?
What is understand in resource tracking?