| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the difference between to_char and to_date
functions? | | 1 |
| package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body | Reliance | 2 |
| How can we schedule the procedure to run automatically ? | | 2 |
| package specification-3 procedures
package body-2 procedures will is execute | | 2 |
| What is the difference between RDBMS and DBMS? | Stag-Computers | 5 |
| What are the types of SQL Statement? | | 2 |
| four procedures is are there should i write their in a package | | 2 |
| what is inline view? | | 4 |
| can i call procedure in package | TCS | 2 |
| Types of joins ? | Digital-GlobalSoft | 3 |
| what is global variable in pl/sql | | 1 |
| declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i into lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end loop;
message(num);
What will be the output ?
| Oracle | 2 |
| What is the difference between anonymous block and named
blocks? | | 1 |
| What is integrity constraints? | Ramco | 3 |
| 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 | 1 |
| how can i read write files from pl/sql | | 1 |
| what is mean by forward declaration and where we'll use it. | TCS | 4 |
| What is RAC in oracle? | | 2 |
| can we create index on index? | iFlex | 3 |
| Which clause of an UPDATE statement allows you to affect
only certain rows of a table?
1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause
| HCL | 5 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
