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 4924

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8427

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 5738

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

Infogain,

1 3006

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

Infogain,

3 8399

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

4 8402

How to find last day of the month in sql query

4 7734

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

2 4814

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 6057

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 5685

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 6712

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

Oracle,

1 6345

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 6515

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 6786

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 9602


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is offset-fetch filter in tsql? : Transact sql

739


How to Execute a Package in PL/SQL.?

860


What is sql mysql pl sql oracle?

835


How many types of cursors supported in pl/sql?

854


what is the difference between blob and text? : Sql dba

780


What is group by in sql?

818


What is range partitioning?

736


What is the mutating table and constraining table?

783


What is spool?

840


When is the update_statistics command used?

819


Is left join inner or outer by default?

802


What is difference between inner join and self join?

847


Can we use ddl commands in pl sql?

821


What are inbuilt functions in sql?

825


Why use subqueries instead of joins?

850