Write a query to find five highest salaries from EMP table. (there is a column SALARY)22 23322
What is meant by Join? What are the different types of Joins available? Explain.5 9479
How will you select unique values from a list of records?7 7833
How will you delete a particular row from a Table?7 7210
What is the difference between the Primary and Foreign key?7 8224
From an Employee table, how will you display the record which has a maximum salary?28 17305
What is nvl function?4 5659
what is 'force view'?3 8567
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?13 9382
what is global temporary tables and how use that tables in pl/sql packages1 5435
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.3 9157
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual5 9904
What are the steps you take to tune(performance tuning) the code in plsql?4 8464
I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.3 4209
which will default fire first statement level trigger or row level trigger2 2480
can anybody send the rrb chennai &rrb bopal question papers of 2006&2007.My exam is on 12 oct 2008.Its urgent
wow to calculate the transformer rating(KVA)
What happens when water mixed with cowdung is used for priming instead of water for lifting water in pumps?
in control scheme dc logic wiring commonly using negative loop,what is the reason?if we use positive looping what will happen?
how to make and keep a human liver culture?
what is payment medium program ? how to config advance payment in app ? payment suplymentary in app?
Can anyone post the SAP-Project systems interview questions.
Write a VLSI program that implements a toll booth controller?
In any Hyderabd institute you can find these word commomly used by faculties ... Yes or no / Right or wrong so funny...
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : email@example.com TIA , Sagar
what is balance sheet, capital budgeting, financial statements, current ratio, profit maximization?
why do u think u r suitable for the field of marketing....????
57. Calculate the volume of a truck loaded with stone chips whose data are as follows– 5 Top Length - 13-9, 13-10, 13-09 Bottom Length - 13-11, 13-10.5, 13-10 Top width - 8-7.5, 8-8, 8-7 Bottom width - 8-7, 8-8, 8-7.5 Depth - 2-0, 1-11.5, 1-10, 1-11, 1 -10.5, 1-11.75, 1-11
Where are log and trace files located?
what are the w3c specifications for xml?