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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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

For More Un-Answered { SQL PLSQL } Questions Click Here