SQL PLSQL Interview Questions
Questions Answers Views Company eMail

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body


2 4555

what is variable in package specification

2 3539

i don't want the message as 14 rows updated just it should update what it will do

4 5070

how can i read files from a pl/sq l program

3 4821

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

Aricent, Bank Of America, Alps, Wipro,

27 27210

what is the command for user data type?

2 6077

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.


14 22913



1 3856

In testing where do we use sql language and how it helps in testing?

2 4283

what command is used to create a table by copying the structure of another table including constraints ?

eicc, CMC,

6 9739

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

50 41474

Difference between views and materialized views?


5 15785

Write a simple program on cursors


2 5040

How to convert ms-excel file to oracle table?

2 6145

what are the different types of joins?

Choice Solutions,

4 6576

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do you use collections in procedure to return the resultset?


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins


Describe the Index, Types of index, At what situation we have used? Which one s better than others?


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


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


What is Temp Table and type of temp table?


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


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


hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification


i have some prob lem to tell me about my self in interview first round ...


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


How global cursor can be declare with dynamic trigger ?


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?


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