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 4753

what is variable in package specification

2 3700

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

4 5308




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

3 4991

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 28795

what is the command for user data type?

2 6233

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 25278

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

AOL,

1 4060




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

2 4437

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

eicc, CMC,

6 10240

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

50 42655

Difference between views and materialized views?

BirlaSoft,

5 16474

Write a simple program on cursors

BirlaSoft,

2 5209

How to convert ms-excel file to oracle table?

2 6357

what are the different types of joins?

Choice Solutions,

4 6744


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

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

1174


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

5421


How global cursor can be declare with dynamic trigger ?

684


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.

787


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

5898


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1557


Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010

941


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

1236


What is AUTH_ID and AUTH_USER in pl/sql ?

371


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

590


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

1858


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

870


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

928


Could you please provide oca (oracle 10g) dumps for my certification ?

2996


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

712