Sign Up Login


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 6951

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

 1 7892

Whate is use of MOD function in pl/sql.

 3 6745

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 5606

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 4935

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 12158

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 16904

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

 1 6190

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

 1 6424

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

 1 3715

Post New Oracle SQL PLSQL Interview Questions


Oracle SQL PLSQL Interview Questions


Un-Answered Questions

How can add the captcha in registration page for drupal?

103

What is special types forms

722

What is the difference between a bulleted and numbered list?

553

Is minecraft java edition free?

805

Where we have to use RCVF and where we have to use SNDRCVF. Basically what is difference between RCVF and SNDRCVF?

1448




Describe validate() and reset() methods.

752

What is Non-Linear Filters?

950

how to rename an existing column in a table? : Sql dba

695

What is structure in c explain with example?

833

how to test use the quality control .how to verify the image verification

2782

which batch require to use for analytical method validation?

539

1234554321 1234 4321 123 321 12 21 1 1 12 21 123 321 1234 4321 1234554321

3407

I am new to testing, I need information about TSYS any website or if you have information please mail it to me. this is for online credit applications project.My mail id is keerthanakoluvu@yahoo.com. Thanks for your help.

1808

What is the vuser in the scenario?

786

what is ccdt file on websphere mq or wmq?

657