|
Question |
Rating |
View Answer |
|
What are the different tablespaces in database |
|
View Answer |
|
What is the maximum number of triggers, can apply to a single table |
|
View Answer |
|
What is the output of SIGN function |
|
View Answer |
|
What are the more common pseudo-columns |
|
View Answer |
|
Other way to replace query result null value with a text |
|
View Answer |
|
What are PL/SQL Cursor Exceptions |
|
View Answer |
|
Any three PL/SQL Exceptions |
|
View Answer |
|
Which date function returns number value |
|
View Answer |
|
Display Odd/ Even number of records |
|
View Answer |
|
Display the number value in Words |
|
View Answer |
|
To view installed Oracle version information |
|
View Answer |
|
Find out nth highest salary from emp table |
|
View Answer |
|
Implicit Cursor attributes |
|
View Answer |
|
Explicit Cursor attributes |
|
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 |
|
How do I display row number with records |
|
View Answer |
|
How do I eliminate the duplicate rows? |
|
View Answer |
|
If a view on a single base table is manipulated will the changes be reflected on the base table |
|
View Answer |
|
If Yes - under what conditions |
|
View Answer |
|
Can a view be updated/inserted/deleted |
|
View Answer |