| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 | 3 |
| Whatis yhe use of cursor ? how cursor allocate context area
for executing the sql statement? | HCL | 2 |
| How do you get all records from 2 tables. Which join do you use? | Microsoft | 3 |
| how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c | Oracle | 4 |
| What are the types of SQL Statement? | | 2 |
| what is the difference between trigger and storedprocedures | Tech-Mahindra | 9 |
| What is the usage of NVL? | Infosys | 5 |
| Delete duplicate records in the emp table. | | 5 |
| how do u call in & out parameters for stored procedures? | A1-Technology | 7 |
| I have a small PL/SQL Block
assume in this way
begin
select * from emp where empno=100;
exception
when others then
<Some Messages>
when no_data_found then
<Some Messages>
when too_many_rows then
<Some Messages>
end;
The question which he asked was whether this block will get
executed normally or it will throw error ?
If errored out then what is the reason for the error ?
Could anybody please help me ?
Regards
Nakul Venkataraman | Satyam | 2 |
| hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
pankit.lodaya@accenture.com | Wipro | 2 |
| How will you a activate/deactivate integrity constraints? | | 1 |
| HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE. | | 2 |
| What is the difference between join and union. | | 10 |
| Begin
For j in 4403201000 .. 4403202000
Loop
If mod (j, 100) = 0 then
Dbms_output.put_line (j);
End if;
End loop;
End;
what will be the output of this question | TCS | 4 |
| Please let me know if UNION ALL and Natural Join does the
same operation and are same... | iGate | 3 |
| What is Referential Integrity? | IBM | 2 |
| Can a view be updated/inserted/deleted?If Yes under what
conditions? | | 3 |
| in materialized view the structure will create immediately
or not? | iFlex | 2 |
| State the advatage and disadvantage of Cursor's? | | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |