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 18026Dear 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 13288SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 10305wirte 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 16300Post New Accenture SQL PLSQL Interview Questions
What is the difference between case version and decode version?
can any send me a forbes marshall dtron 316 manual
You have 5 jars of pills. Each pill weighs 10 grams, except for contaminated pills contained in one jar, where each pill weighs 9 grams. Given a scale, how could you tell which jar had the contaminated pills in just one measurement?
What are the challenges in applying AI to environmental issues?
What made you choose webi over other reporting tools?
Do you have the qualities and skills necessary to succeed in your career at Starbucks?
Which automation anywhere version you have worked on?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What do you know about the recent satellite launch?
Anybody please send me the papers of the reliance exam (apti and tech) so that i can go through it) mail me at raminder_verma@rediffmail.com
What are HP's objectives for the coming year?
How to add / link an images/css/javascript from a view in ci?
Please send me the ongc old question papers
rrbchennaimodel question paper for current papers
How to calculate VCB rating for 33KV ,25 MW Power line?