| Other SQL PLSQL Interview Questions |
|| Asked @
|Types of joins ?
|what command is used to create a table by copying the
structure of another table including constraints ?
|Give an example of any procedure.
|I need to write a simple query,which one is better select
statement or stored procedure?and why?
|What is a transaction?
|How to maintain the history of code changes of pl/sql?
|I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS
|Write the order of precedence for validation of a column in
a table ?
|i have xml source. xml source having lacks of records. i
want extract/retrive xml source data using sql query.
please tell me how to write query.
|What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
|how to retrieve the top 3 salaries of the table using rownum
|write a query to delete similar records in particular
fields(columns) in different tables
|For more SQL PLSQL Interview Questions Click Here |