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 17800Dear 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 12918SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10123wirte 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 15833Post New Accenture SQL PLSQL Interview Questions
What is periodic processing in fi-aa? : fi- asset accounting
What is awb?
what are the two different smart groups in Xcode?
How can the partner of sap support the migration of customer to sap s/4hana?
What are the different types of ejb?
What is the command to find hidden files in the current directory?
Is xml html?
How can we improve the performance of a crystal report?
What do you understand by jdbc statements?
What is Erosion in a control valve?
What is the difference between the functions strstr() and stristr()?
Explain normalization in one line?
How can the output be redirected to some other action process in place showing it in the screen?
Which of the Angular life cycle component execution happens when a data-bound input value updates?
What is an ocx?