Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 5809

what is variable in package specification

2 4641

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

4 6544

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

3 6255

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?

Alps, Aricent, Bank Of America, Wipro,

27 36031

what is the command for user data type?

2 7122

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,

15 37284

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

AOL,

1 4750

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

2 5604

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

CMC, eicc,

6 12258

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

50 50622

Difference between views and materialized views?

BirlaSoft,

5 18516

Write a simple program on cursors

BirlaSoft,

2 6084

How to convert ms-excel file to oracle table?

2 7236

what are the different types of joins?

Choice Solutions,

4 7812


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What is the command used to fetch the first 5 characters of a string?

226


What is restrict in sql?

148


How do you delete a table?

136


Can we use join in subquery?

151


what is the difference between truncate and drop statements? : Sql dba

151






What are the indexing methods?

138


How do we accept inputs from user during runtime?

169


What is 19 null in sql?

139


What is keys and its types?

138


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.

763


How to fetch alternate records from a table?

169


Explain spool.

191


How to execute a stored procedure?

158


What is synonyms?

173


What is mutating trigger?

135