Write a query to get 2nd maximum salary in an employee table ?68 75045
What is an index and types of indexes. How many number of indexes can be used per table ?12 69602
What is a constraint. Types of constraints ?5 19729
What is a trigger ?10 12528
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 11504
will function return more than one value how9 15474
what is purge command explain about oracle performance tuning2 20022
Give an example of any procedure.5 11002
How will we see framework of a table?2 7600
When we give SELECT * FROM EMP; How does oracle respond?24 35200
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 6042
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 6752
What is different between union and minus?7 16051
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 8935
What is the relation b/w view and trigger3 8601
what is the current setting for different relay protection for transformer .
accounting document is not getting generated for sto process. where is the control for this ? Thanks in advance
What is meant by a stray loss of a induction motor??? What is the equation to find it
If you face any problem in your current organization then mention how would you solve the problem and benefit the company? (Describe it below in 300 words).
it will become easy if uuu provide website linkssss and list of consultanciessssss
Does functional module level configuration come under workbench request or customizing request?
what is the diff bw sql direct and jdbc update can't we do select and updating operation in sql direct
hai, kindly send anyone for output workers format details for construction project in foundation to finishing.
How to size fuse? How to size MCB?
What are the treatment & implications if party doesn't provide C Form in interstate sales transactions & also same if provide C Form.
Use of coping on terrace wall and in 4" wall is compulsory or not ?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
What is meant by Authorization Mechanism in Laravel ?
what is meant by codan optimisation m rna enrichment?
what is droop control?