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 4448

what is variable in package specification

2 3459

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

4 4980

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

3 4725

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 26322

what is the command for user data type?

2 5999

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 22189



1 3789

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

2 4147

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

eicc, CMC,

6 9557

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

50 40475

Difference between views and materialized views?


5 15531

Write a simple program on cursors


2 4954

How to convert ms-excel file to oracle table?

2 6060

what are the different types of joins?

Choice Solutions,

4 6453

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

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.


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


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


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


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


what is try_catch block in procedure


a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution


What packages(if any) has oracle provided for use by developers?


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????


what is the bond code in materialized view?


Difference between global and parameter variables?


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews


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


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


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