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

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

 1 4523

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8041

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

Pitney Bowes,

1 5317

What is the criteria while applying index to any column on any table.

Infogain,

1 2605

What is the diffrence between IN and EXISTS.which one is faster.

Infogain,

3 7835

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

 4 7709

How to find last day of the month in sql query

 4 7039

Fetch an entire row from the employees table for a specific employee ID:

 2 4315

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

 3 5444

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

 3 5122

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

 4 6051

while loading data into database how can u skip header and footer records in sql*loader

Oracle,

1 5810

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

Oracle, Wipro,

1 6038

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

Parexel,

1 6372

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

MTS,

7 8582

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do you respond to dementia behavior?

520

How to order siblings in oracle hierarchy queries?

593

How many joins can you have in sql?

503

Why do we need databases?

557

What is over () in sql?

518




What are the built in functions of sql?

551

What is a heap in sql?

516

What are the sql aggregate functions?

600

What is data profiling in sql?

507

Do we need to rebuild index after truncate?

520

Is there any restriction on the use of union in embedded sql?

663

Explain raise_application_error.

637

Are views faster than queries?

530

What is difference between sql and mysql?

521

What is group function in sql?

522

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