|
Question |
Rating |
View Answer |
|
Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text “Not Applicable” want to display, instead of blank space. How do I write the query |
|
View Answer |
|
The use of HAVING , WHERE and GROUPBY in one SQL |
|
View Answer |
|
You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done? |
|
View Answer |
|
If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE |
|
View Answer |
|
How to get/select the nth row from the table ? How to select first n rows ,last n rows from a table
|
|
View Answer |
|
What is CYCLE/NO CYCLE in a Sequence |
|
View Answer |
|
How do I eliminate the duplicate rows? |
|
View Answer |
|
Is it possible to access the current value in a session before accessing next value |
|
View Answer |
|
What are the different types of SQL |
|
View Answer |
|
What is a corelated subquery |
|
View Answer |
|
What is correlated sub-query |
|
View Answer |
|
What is a Cartesian product? |
|
View Answer |
|
What are the advantages of VIEW |
|
View Answer |
|
What is a database link |
|
View Answer |
|
What is difference between CHAR and VARCHAR2? |
|
View Answer |
|
What are the different tablespaces in database |
|
View Answer |
|
What is meant by Scrollable cursor |
|
View Answer |
|
Display Odd/ Even number of records |
|
View Answer |
|
What is meant by SORTING and GROUPING |
|
View Answer |
|
What is correlated sub-query ? |
|
View Answer |