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 7065

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

1 7969

Whate is use of MOD function in pl/sql.

3 6866

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 5690

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 4993

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 12320

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 17047

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

1 6341

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

1 6511

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

1 3814

Post New Oracle SQL PLSQL Interview Questions


Oracle SQL PLSQL Interview Questions


Un-Answered Questions

What is meant by in-memory processing in Spark?

259


What tool and ide is used for node.js?

369


what is timeframe for conversion?

5


How to extract HBV cccDNA from heptoma cell lines?

2220


What are the different types of a stream?

774


What is the Model testing in Machine Learning?

214


Is apache spark a database?

266


What is environmental variable? Where we will use this variable?

341


What are standard actions in JSP?

727


What I can do with c#?

740


What is a wchar_t in c++?

834


What is a macro?

901


What is motor sequence learning?

73


Suppose you win $5 million lottery, then, would you still work?

1092


What is final keyword in java? Give an example.

795