Sign Up Login


  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 4892

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8404

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 5707

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

Infogain,

1 2971

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

Infogain,

3 8361

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

 4 8345

How to find last day of the month in sql query

 4 7696

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

 2 4780

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 6017

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 5654

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 6674

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

Oracle,

1 6300

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 6478

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 6755

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 9536

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Can a table contain multiple primary key’s?

842

What is the current version of sql?

758

What is the difference between microsoft access and sql server?

746

What are sql functions? Describe in brief different types of sql functions?

755

What is the syntax to add a record to a table?

811

What is the difference between local variables and global variables?

834

How do I run a pl sql procedure in sql developer?

725

Which join condition can be specified using on clause?

739

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

795

What is sql analyzer?

782

What is sql prepared statement?

766

What packages are available to pl/sql developers?

833

How to use sql statements in pl/sql?

823

What is keys and its types?

809

Explain select statements in sql?

787

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