Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Are there any features that are decommissioned in 11g that are not present in 11g?

 2148

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

Wipro,

2496

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

 2 6928

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

TCS,

9 11071

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 8900

What is the differnce between view and materialized view

TCS,

4 9175

What is dynamic SQl and how you will create and execute dynamic sql?

TCS,

2 7463

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 38312

How many null values can be inserted in a coulmn whihc is unique constraint

Flextronics,

8 13237

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

Flextronics,

1 5506

What is the difference between SQL and PLSQL

IBM,

7 11236

query to retrive the employees whose sal is greater than avg sal

TCS,

10 15193

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

Cap Gemini, TCS,

13 23706

select sal from emp group by sal

TCS,

3 6383

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

IBM,

21 27590

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql a case sensitive language?

943

what are the type of locks ? : Sql dba

965

how are mysql timestamps seen to a user? : Sql dba

1139

What is the benefit of foreign key?

1022

What is not in sql?

945

What is a temporal data type?

1052

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

959

How to run pl/sql statements in sql*plus?

1079

how do you tune the slow running queries in oracle db , explain the methodology

2776

How to get list of all tables from a database?

1160

Is sql procedural language?

967

what is table? : Sql dba

1062

What is %type in sql?

965

how to do backup entire database? : Transact sql

1143

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

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