|
Question |
Rating |
View Answer |
|
What SQLPlus command is used to format output from a select? |
|
View Answer |
|
What is ROWID ? |
|
View Answer |
|
How do I display row number with records |
|
View Answer |
|
What is the maximum number of triggers, can apply to a single table |
|
View Answer |
|
Can a view be updated/inserted/deleted |
|
View Answer |
|
Display the number value in Words |
|
View Answer |
|
You want to use SQL to build SQL, what is this called and give an example |
|
View Answer |
|
What is a join ? Explain the different types of joins ? |
|
View Answer |
|
How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ? |
|
View Answer |
|
If a View on a single base table is manipulated will the changes be reflected on the base table ? |
|
View Answer |
|
What is an integrity constraint |
|
View Answer |
|
Other way to replace query result null value with a text |
|
View Answer |
|
What is difference between TRUNCATE & DELETE |
|
View Answer |
|
What is explain plan and how is it used? |
|
View Answer |
|
What are the types of SQL Statement ? |
|
View Answer |
|
What is the usage of SAVEPOINTS |
|
View Answer |
|
How many LONG columns are allowed in a table |
|
View Answer |
|
If a view on a single base table is manipulated will the changes be reflected on the base table |
|
View Answer |
|
To view installed Oracle version information |
|
View Answer |
|
Explain Connect by Prior ? |
|
View Answer |