Write a query to get 2nd maximum salary in an employee table ?68 73388
What is an index and types of indexes. How many number of indexes can be used per table ?12 68697
What is a constraint. Types of constraints ?5 19379
What is a trigger ?10 12196
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 11081
will function return more than one value how9 15012
what is purge command explain about oracle performance tuning2 19634
Give an example of any procedure.5 10688
How will we see framework of a table?2 7366
When we give SELECT * FROM EMP; How does oracle respond?24 34244
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 5736
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 6549
What is different between union and minus?7 15534
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 8650
What is the relation b/w view and trigger3 8283
if we use 1.25 bag of cement 3 pharma metal and 2 pharma crush sand what is the strenghtexpected for RCC column
can external audit be seen as merely an overhead cost adding no value to the orgnisation
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
i am exeprienced person what is selection process
i am a animation student. in december i am going to face an interview so plse tell me what type of question they will ask ( about animation) how should i tell the answer (i am poor in comunication skill) pls tell me some tips its help full to me
In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?
Where do we show "Dividend paid in FFS ,either in FFO or in FFS? what is teh concept behind?
Hi,can anyone help me out with PhD programs related to Instrumentation field?I have a degree in electronic Instrumentation?
WHAT IS THE MEAN BY DEALER MANAGEMENT IN THE AUTO MOBILE COMPANY?
How to create SQL queries with SQL Builder?
i am new to this tax system if you don't mine "please help me"
how to convert the recors form vsam file to db2 table tru file aid
Explain CMOS Inverter transfer characteristics?
wat is mass allocation and when it is used
What is supporting documents enclosed & must be required to Submit of quarterly & Yearly Sale Tax Return (Haryana)