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 5232

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

1 6129

Whate is use of MOD function in pl/sql.

3 4883

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 3874

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 3644





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 8907

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 12735

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

1 4827

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

1 5015

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

1 2412

Post New Oracle SQL PLSQL Interview Questions




Oracle SQL PLSQL Interview Questions


Un-Answered Questions

How do you sort sheets?

3


Can a spreadsheet be used as a database?

3


Name a jenkins environment variable you have used in a shell script or batch file.

1


What is splunk tool?

27


How do you copy a formula in excel and drag it?

3






What is encapsulation in python?

61


What is the use of welcome-file-list?

108


Take an MxN matrice from user and then sum upper diagonal in a variable and lower diagonal in a separate variables. Print the result

889


What is the History of Cassandra Database ?

7


Is aws a cloud?

1


What are the different types of bots and when are they used in automation anywhere?

1


What are the uses of grouping activities ?

129


How do I know if mongodb is installed?

1


What is hibernate bag collection?

1


What is reverse path check?

52