SQL PLSQL Interview Questions
Questions Answers Views Company eMail

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

TCS, Saama Tech,

3 6702

What is your daily office routine?

Data Vision,


which will default fire firstĀ  statement level trigger or row level trigger

Data Vision, Cap Gemini,

2 4735

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.


1 1507

How did you export data from database to excel file.


1 3248

Difference between global and parameter variables?



What is extent clause in table space?


1 1396

What is the use of time stamp in select statement?


1 1828

Which data type doesn't allow null data type?


6 4611

What is window clause?


1 2106

Can you alter start with clause?


1 2645

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

JPMorgan Chase,

3 5372

write a query to find 4th max salary

7 3112

How global cursor can be declare with dynamic trigger ?


how view used for security purposes?

Glam India,

3 2757

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What packages(if any) has oracle provided for use by developers?


Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com


write a query that returns first characters of each word in Oracel/Sql pl sql


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?


what is try_catch block in procedure


what is the bond code in materialized view?


Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000


What is Materialized View? In What Scenario we Use Materialized View?


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc


Are there any features that are decommissioned in 11g that are not present in 11g?


What is your daily office routine?


when MSQL8.0 is in market


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?