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?

 2140

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,

2491

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 6918

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 11058

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 8879

What is the differnce between view and materialized view

TCS,

4 9160

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

TCS,

2 7458

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 38250

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

Flextronics,

8 13206

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

Flextronics,

1 5501

What is the difference between SQL and PLSQL

IBM,

7 11205

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

TCS,

10 15166

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 23656

select sal from emp group by sal

TCS,

3 6378

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

IBM,

21 27561

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How can you load multi line records? : aql loader

1071

What is the difference between delete, truncate and drop command?

1142

What is the most common sql injection tool?

1037

Explain the difference between rename and alias?

1010

What is case function?

1034

what is a database lock ? : Sql dba

1162

how to get a list of all tables in a database? : Sql dba

974

what is table? : Sql dba

1057

What is the use of sqlerrd 3?

939

explain primary keys and auto increment fields in mysql : sql dba

972

What is an inconsistent dependency?

1044

What is snowflake sql?

1069

What will you get by the cursor attribute sql%notfound?

1057

What are the different types of tables in sql?

999

How to order siblings in oracle hierarchy queries?

1038

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