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,

1161

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.

TCS,

1 1507

How did you export data from database to excel file.

TCS,

1 3248

Difference between global and parameter variables?

TCS,

769

What is extent clause in table space?

TCS,

1 1396

What is the use of time stamp in select statement?

TCS,

1 1828




Which data type doesn't allow null data type?

TCS,

6 4611

What is window clause?

TCS,

1 2106

Can you alter start with clause?

TCS,

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 ?

932

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?

3855


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

1403


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

6122


- 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?

528


what is try_catch block in procedure

520






what is the bond code in materialized view?

1705


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

6015


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

906


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

6852


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

2203


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

793


What is your daily office routine?

1161


when MSQL8.0 is in market

942


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

1093


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1831