Oracle SQL PLSQL Interview Questions Answers, Oracle Placement Papers, Oracle Technical, HR Interview Questions, Oracle Aptitude Test Questions, Oracle Campus Placements Exam Questions

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 7501

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

1 8259

Whate is use of MOD function in pl/sql.

3 7355

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 6092

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 5273

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 13053

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 17691

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

1 6742

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

1 6876

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

1 4164

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

What is the ribbon toolbar?

548

IS THERE ANY EQUIPMENT TO CHECK AND CALCULATE THE POLARITY OF A LIQUID?

2395

How does broadcast join work in spark?

284

Explain what is the difference between a string copy (strcpy) and a memory copy (memcpy)? When should each be used?

1039

Explain the Doric chiton

What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?

1009

What is difference between post and put method?

988

How to open a file in Ruby?

Cheque Received From Customer What is accounting entry and in which vocher. coustomer order is 100 items . 5 items given to customer cost rs 2000 5 items Total 2000 and remaing 95 items not deliveried 100000 Cheque Received

2063

Can you vlookup across multiple sheets?

563

How many namespaces are there in c++?

1014

While packaging the web application defaultwebapp for deployment into the weblogic server, the home and remote interfaces of the enterprise beans used by the servlets should reside in which directory? : BEA Weblogic

962

Tell us what kind of work environment do you prefer?

1050

What is cascade in hibernate in which scenario we use it?

335

Define cause effect graphing?

1061