| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to fetch the rows by dynamicaly passing table name
through cursor? | | 2 |
| what is difference between stored procedures and
application procedures,stored function and application
function?
| | 1 |
| Wat is SGA ? | ABB | 1 |
| How the execution will be done in exceptions? | | 2 |
| Hello All, Could any well write a query for the following
scenario.
Account(table name)
No Name Amount
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.50
4 JKLM 4000.00
5 MNOP 6000.00
O/p Should be in this format
No Name Credit Debit
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.50
4 JKLM 0 -4000.00
5 MNOP 6000.00 o
could any one give appropriate query for this
Thnks in Advance
Suneel Reddy | Target | 4 |
| what is difference between procedure and function | Wipro | 5 |
| can we use out parameter in a function?Give an example. | Logica-CMG | 2 |
| what is the difference between implicit conversions and
explicit conversions? | | 1 |
| What is pragma exception and how, when, where us | | 4 |
| What is the difference between SQL table and the PLSQL
table? | Mastek | 1 |
| Types of locks in database ? | TCS | 5 |
| define primary key & secondary key?
| | 1 |
| Create table emp
(id number(9), name varchar2(20),salary
number(9,2));
The table has 100 records after table created.Now i nee to
change id's Datatype is to be Varchar2(15). now
Alter table emp modify(id varchar2(15),name varchar2(20),
salary number(9,2));
Whether it will work or returns error? post answer with
explanation. | TCS | 7 |
| How are multiple column = value pairs delimited in the SET
clause of an UPDATE statement?
1. With commas (SET price = 0, status = 'I')
2. With parentheses (SET (price = 0) (status = 'I'))
3. With double-pipes (SET price = 0 || status = 'I')
4. With square-brackets (SET [price = 0] [status = 'I']
5. With single or multiple spaces (SET price = 0 status
= 'I')
| | 2 |
| mail-id table contains two columns(email_id,userid)
it contains different types of mail-ids,and no of users.
here username length is differ na,(ex-
tamil@yahoo.com,joshua@hotmail.com like)
now i want to fetch the email-ids only starting from '@'
(ex-@gmail.com,@yahoo.com,@hotmail.com | | 4 |
| Can we relate two different tables from two different users
in ORACLE,PL/SQL? | | 4 |
| How to execute OS(operating system) command from pl/sql? | | 3 |
| using subquery how can i calculate working days in a month? | Spice-Telecom | 2 |
| what is the need of the cursor attribute notfound..(because
using found attribute we can complete the task......found +
negation operator = not found ) | Tech-Mahindra | 1 |
| how a reference cursor works?what all adnvantages are
gained with it..specify the situation? | TCS | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
