SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how are rank and dense rank being alloted for column with same values over a particular column

1 1418

what are sequences

1084

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

802

What is Difference Between Unique and Primary Key Constraints?

Wipro,

602

What is a Mapplet?

Informatica,

639

How to change the order of columns in Oracle SQL Plus ?

MCN Solutions,

606

How to display Row Number with Records in Oracle SQL Plus?

MCN Solutions,

585

How to display the records between two range in Oracle SQL Plus?

MCN Solutions,

636

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

MCN Solutions,

592

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

MCN Solutions,

711

Can a procedure in a package be overloaded?

EXL,

540

Can procedure in package be overloaded?

EXL,

604

Can procedure in a package be overloaded?

HCL,

1 864

Inline the values in PL/SQL, what does it mean.?

MCN Solutions,

621

How can we store rows in PL/SQL using array?

MCN Solutions,

657


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to get list of all tables from a database?

623


Why is pl sql used?

521


how many tables will create when we create table, what are they? : Sql dba

535


what is sub-query? : Transact sql

590


What is a schema sql?

522






What is a temporal table?

488


what is commit? : Sql dba

612


What is sql*loader and what is it used for? : aql loader

612


What is pl sql architecture?

496


What is the purpose of normalization?

531


What is rownum in sql?

557


What is oracle pl sql developer?

528


how to increment dates by 1 in mysql? : Sql dba

539


What are the built in functions of sql?

551


What is auto increment feature in sql?

613