Write a query to find five highest salaries from EMP table. (there is a column SALARY)22 30612
What is meant by Join? What are the different types of Joins available? Explain.5 11650
How will you select unique values from a list of records?7 10475
How will you delete a particular row from a Table?7 9704
What is the difference between the Primary and Foreign key?7 10382
From an Employee table, how will you display the record which has a maximum salary?29 20903
What is nvl function?4 7731
what is 'force view'?3 10873
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 12321
what is global temporary tables and how use that tables in pl/sql packages1 7148
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 12001
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual6 12792
What are the steps you take to tune(performance tuning) the code in plsql?4 11202
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 6039
which will default fire first statement level trigger or row level trigger2 4326
Define the difference between a stable versus an unstable controlled system and some of the tools you might use to be able to detect when this is happening and assumptions used for control system application design that could contribute to instability
What is effect of over voltage and under voltage on ACB
Describe about Lignin degrading microbe ?
How to Form Local Addresses?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How Can We Justify the,Real A/C & Nominal A/C?
how to dispaly ascendimg in pick list
In Rcc ratio calculation I wanted to know quantity of Steel also.
Have you done Migration? How to build in PeopleSoft ? Why build from Oracle?
how to calculate reinforcment in staircase cranked beam?
Describe about luciferase reporter assay?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
dynamic programming in sap abap
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
What is sales and operational planning(S&OP)process and what are the advantages of S&OP process?