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?

 2194

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,

2550

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 7033

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 11329

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 9051

What is the differnce between view and materialized view

TCS,

4 9338

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

TCS,

2 7556

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 38738

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

Flextronics,

8 13440

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

Flextronics,

1 5604

What is the difference between SQL and PLSQL

IBM,

7 11443

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

TCS,

10 15514

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 24017

select sal from emp group by sal

TCS,

3 6500

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

IBM,

21 28299

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Why is %isopen always false for an implicit cursor?

1151

What is loop in pl sql?

1078

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2609

what happens if null values are involved in expressions? : Sql dba

1090

How to assign sql query results to pl sql variables?

1145

How can we debug in PL/SQL?

1181

what is the syntax for using sql_variant_property? : Transact sql

1081

What is the difference between mdf and ndf files?

1157

What are two statement types in sql?

1156

Explain exception handling in pl/sql?

1080

Is left join and outer join same?

1114

What is the difference between delete and truncate statement in sql?

1124

What are the types of join and explain each?

1100

Does mysql_real_escape_string prevent sql injection?

993

How do you update a value in sql?

1100

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