| Other SQL PLSQL Interview Questions |
|| Asked @
|How to create a table using constraints...
IF i change the PARENT KEY value ,then CHILD KEY
table will also to change in the another table...
plz reply ur answers @ firstname.lastname@example.org
|which will fire first ? Trigger or Constraint
|HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
|Can you have multiple SPs with the same name on a database?
|How to execute multiple sql statements in a single annonymous
block irrespective of the sql statement result?
|What is the difference between anonymous block and named
|How to export the table data (this table having 18 million
records) to .csv file. Please tell me is there any faster
way to export the data.
|Can i possible to see Table Details ?
Table Name Date Time User
Emp May/18/2010 12:59pm Scott
|What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
|define a variable representing the expression used to
calculate on emps total annual remuneration.use the
variable in a statement which finds all emps who can earn
30000 a year or more.
|What is Primary Key?
|Types of joins ?
|For more SQL PLSQL Interview Questions Click Here |