Write a query to get 2nd maximum salary in an employee table ?68 80681
What is an index and types of indexes. How many number of indexes can be used per table ?12 72272
What is a constraint. Types of constraints ?5 20737
What is a trigger ?10 13762
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 12748
will function return more than one value how9 16942
what is purge command explain about oracle performance tuning2 21255
Give an example of any procedure.5 11911
How will we see framework of a table?2 8323
When we give SELECT * FROM EMP; How does oracle respond?24 38762
Dear 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 7075
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 7347
What is different between union and minus?7 17668
wirte 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-20105 9974
What is the relation b/w view and trigger3 9777
Who is a authorised Dealer?
What are the types of ami provided by aws?
How to create a dml trigger using create trigger statements?
When we use Abstract Class and when we use Interface?where we will implement in real time?
What is the difference between Functional testing and Unit Functionality testing?
What is the maximum zoom size in powerpoint?
How do we write components in apache tapestry?
Can one take ayurveda medicine with modern medicines?
What floating point types is supported in C#?
What is error of a measurement?
can we make game by using c
Define Data provider?
how technical is calculated in 11kv line and lt line
What is file and example?
What is Acquisition?