|
Question |
Rating |
View Answer |
|
Give the structure of the function ? |
|
View Answer |
|
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ? |
|
View Answer |
|
What are the return values of functions SQLCODE and SQLERRM ? |
|
View Answer |
|
The IN operator may be used if you know the exact value you want to return for at least one of the columns. |
|
View Answer |
|
What will happen after commit statement ? |
|
View Answer |
|
What are the PL/SQL Statements used in cursor processing ? |
|
View Answer |
|
Name the tables where characteristics of Package, procedure and functions are stored ? |
|
View Answer |
|
How to debug the procedure ? |
|
View Answer |
|
What is Data types? |
|
View Answer |
|
Question: Below is the table
city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e
I want the o/p as follows:
male female delhi 2 1 mumbai 1 1
Please help me in writing the query that can yield the o/p mentioned above? |
|
View Answer |
|
Explian rowid,rownum?What are the pseduocolumns we have?
|
|
View Answer |
|
What are two virtual tables available during database trigger execution ? |
|
View Answer |
|
What is an Exception ? What are types of Exception ? |
|
View Answer |
|
What is pl/sql?what are the advantages of pl/sql? |
|
View Answer |
|
How to disable multiple triggers of a table at at a time?
|
|
View Answer |
|
What is Savepoint? |
|
View Answer |
|
What is Intersect? |
|
View Answer |
|
What is PL/SQL ? |
|
View Answer |
|
What is SET? |
|
View Answer |
|
What are the Restrictions on Cursor Variables?
|
|
View Answer |