What is the use of aggregate functions in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Write a syntax for update query in oracle?
What are named parameters?
What is MTTR advisor in Oracle?
What are the type of Synonyms?
12 RULES OF RDBMS
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is ordinary table in oracle?
List out the difference between commit, rollback, and savepoint?
What is the exact use of Collections?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
What are privileges and grants?