| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 1> how are u debugging in plsql ?
2> how to connect oracle database from unix. is there ne
way other than using sqlplus ? | | 2 |
| how to insert values like 10:10:00,30:25:00 etc.into table
after insert how can i sum the above insert values to get
the result as 40:35:00 | | 2 |
| How do you assign Construct the where clause without
concatenating Field,value pairs? | Microsoft | 1 |
| What is the best strategy to use COMMIT in a pl/sql loop? | | 2 |
| What is the difference between DELETE and TRUNCATE? | Tech-Mahindra | 14 |
| in a package one procedure is wrong package shows valid or not | | 3 |
| what command is used to create a table by copying the
structure of another table including constraints ? | eicc | 4 |
| how to create a database in oracle? | | 2 |
| what is the difference between the query and corelated
query | IBM | 6 |
| What is the default value of CHAR type? | Bosch | 1 |
| what is the output of this query selet * from employee
where 1=2 ?? | | 6 |
| Can a table have two primary keys? | HCL | 25 |
| How to add Foreign key in a table after the creation of the
table? | Satyam | 3 |
| What is difference between TRUNCATE & DELETE? | TCS | 12 |
| write a qurey for finding the length of the sting. | Infosys | 4 |
| What is an Exception ? What are types of Exception ? | | 2 |
| Regarding joins what are the differences you observed in
oracle 9i and sql server? | Choice-Solutions | 3 |
| Write a query to get 2nd maximum salary in an employee table ? | TCS | 27 |
| 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
| Polaris | 2 |
| four procedures is are there should i write their in a package | | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
