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

write sub query for eliminating duplicate rows using analytical function?

Metric Stream,

3 11707

what is switch column,colums cost in oracle?

Metric Stream,

3115

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

Metric Stream,

1 8507

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

TCS,

3 7571

display records from 5 to 9 using rowid or rownum

Agile Software,

5 14098

How to update salary of employees department wise?

 6 13160

what are the methods using performance tunning in sql and pl/sql

 2 5529

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

IBM, Loginworks, OFSS,

2 9632

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

 3 6126

How do you use collections in procedure to return the resultset?

 1774

How to get second highest salary from a table

 3 5942

What is the maximum number of triggers,can apply to a single table?

 2 7891

What packages(if any) has oracle provided for use by developers?

 1 5000

25.67,-1 Trunc = 20 Round= 30 HOW????

Karrox,

2 6688

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

Oracle,

2 5052

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2553

How do I sort a table in sql?

581

What are schema-level triggers?

566

What is the advantage of index in sql?

524

how many tables will create when we create table, what are they? : Sql dba

525




Is nosql faster than sql?

530

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

603

which types of join is used in sql widely? : Sql dba

531

What are stuff and replace function?

559

What do you mean by query optimization?

539

What are keys in sql?

534

Can we join 3 tables in sql?

481

Why is the cursor important?

521

How to return an array from java to pl/sql?

578

What is the maximum number of triggers, you can apply on a single table?

526

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