Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Oracle SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the main difference between join and subqurey?

 3 6438

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

 1 7539

Whate is use of MOD function in pl/sql.

 3 6193

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.

2 5068

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_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 4600

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

 6 11410

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

 3 16146

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

 1 5810

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

 1 6038

I want to execute a piece of code before calling a procedure. How to achieve it?

 1 3320

Post New Oracle SQL PLSQL Interview Questions


Oracle SQL PLSQL Interview Questions


Un-Answered Questions

How do I insert a formula in visio?

315

What Is Multicast And Unicast In Weblogic ?

627

What is the difference between fopen() and fclose()?

581

Briefly explain various access specifiers in C++.

554

How do I password protect an excel document that is read only?

298




Tell us what is souring?

1

Explain the difference between creating an effect and setting the target as opposed to adding an effectlistener?

1

What is palindrome in java?

550

How many cells in ms excel?

284

What is the requirement of virtualization platform in implementing cloud?

515

What is the difference between a hub and a switch?

198

Can you explain, when to use if-else if-else over switch statements?

531

I need HT sphere gap calibration table. Can any body help me.

1518

What is the max no of match code id's that can be defined for one match code object? : abap data dictionary

638

Choosing between belongs_to and has_one?

475