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

Reliance,

2 4604

what is variable in package specification

2 3580

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

4 5124




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

3 4845

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 27599

what is the command for user data type?

2 6108

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.

Wipro,

14 23343

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

AOL,

1 3885




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

2 4321

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

eicc, CMC,

6 9835

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

50 41787

Difference between views and materialized views?

BirlaSoft,

5 15916

Write a simple program on cursors

BirlaSoft,

2 5074

How to convert ms-excel file to oracle table?

2 6187

what are the different types of joins?

Choice Solutions,

4 6612


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

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

523


First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

183


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

186


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

699


what is single byte over head in oracle..?

899


What are code pages ?

800


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1427


what is try_catch block in procedure

219


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

4766


What is Temp Table and type of temp table?

362


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1753


what is the difference difference between procedure and packages

4104


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

228


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

976


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

680