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 7492

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

1 8254

Whate is use of MOD function in pl/sql.

3 7343

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 6089

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 5269

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 13037

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 17682

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

1 6736

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

1 6869

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

1 4158

Post New Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions

Oracle SQL PLSQL Interview Questions (40)

Un-Answered Questions

Describe python usage in web programming?

929

How can you create a work center for packing in sap ewm system?

747

Which ASP.NET configuration options are supported in the ASP.NET implementation on the shared web hosting platform?

1072

What is polyfill?

What is h:graphicimage tag in jsf (javaserver faces)?

How many types of css can be included in html?

810

What is misl?

1000

What are the steps you should follow to start sql server in single-user mode?

846

what kelvin's law ?

2041

What does a disposition of (new,catlg,keep) for a dsn mean?

1069

Is it possible to break javascript code into several lines?

1488

What is agenda of quick off meeting ?

1059

What is xhtml explain?

1217

What is wamp for?

185

Hi, Can anyone proivde the soluiton for the below senirio, thanks in advance. We are providing test services to various sites of a corporate. Now, we want to bill as a single bill point i.e. Corporate office. Single bill for each site will be generated. E.g. Panac Labs, New Delhi Head Office Panac Labs, Mumbai Lab at Mumbai Panac Labs, Kolkata Lab at Kolkata Panac Labs, Indore Lab at Indore In above case, we are cattering services to all four locations. However, New Delhi is the Head office and Lab too. Hence we will issue four bills addressed to Panac Labs, New Delhi. Outstanding and debtors will be maintained on A/c of Panac Labs, Head office. We also want to maintain sub- ledger base on sites

2177