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 4134

what is variable in package specification

2 3248

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

4 4729

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

3 4536

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 24372

what is the command for user data type?

2 5795

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,

13 20371

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

AOL,

1 3688

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

2 3985

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

eicc, CMC,

5 9136

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

50 38191

Difference between views and materialized views?

BirlaSoft,

5 14339

Write a simple program on cursors

BirlaSoft,

2 4744

How to convert ms-excel file to oracle table?

2 5858

what are the different types of joins?

Choice Solutions,

4 6238


Post New SQL PLSQL Questions


Un-Answered Questions { SQL PLSQL }

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

1487


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

1889


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

4772


Difference between global and parameter variables?

318


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

2906


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

602


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

450


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

407


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

744


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1288


C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

938


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

56


What is extent clause in table space?

346


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

862


what is the bond code in materialized view?

1133