Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 5490

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

1 6428

Whate is use of MOD function in pl/sql.

3 5171

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 4193

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 3861





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 9393

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 13341

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

1 5020

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

1 5204

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

1 2626

Post New Oracle SQL PLSQL Interview Questions




Oracle SQL PLSQL Interview Questions


Un-Answered Questions

How long does startup repair take in windows 7?

150


How to rename a table in DB2 ?

267


You are a contract project manager working with the State of Bliss. Your latest project involves rewriting the Department of Revenue's income tax system. One of the key stakeholders is a huge movie huff, and she has the power to promote you into a better position at the conclusion of this project. She's discovered that one of her favorite superstars lives in the State of Bliss and therefore must file income tax star. What is the most appropriate response? A. Report her to the management team B. Refuse to comply with the request, citing conflict of interest and violation of confidential company data C. Look up the information she's requested. Since the data is considered part of the project, there is no conflict of interest D. You believe that tax records are public information, so you comply with the request

219


Explain the overview of hadoop history breifly?

142


what is meant by power and distribution transformer ?

1134






What is the purpose of the analyzer in petrochemical plant?

2923


What are the most commonly defined input formats in Hadoop?

523


What is jdbc and odbc in java?

169


What oracle weblogic server includes?

197


Explain binding instances?

158


Mention some types of transformation?

226


Is there any relevant technique to produce power from light and heat energy of the sun simultaneosly from same rays of light?

1017


What happen when neutral point connected to core balance current transformer? (Neutral point of an alternator of a 180KVA DG. Neutral point connected to CBCT means enter to the CBCT)

1464


Can an mdb be a message producer or both a producer and consumer? : BEA Weblogic

185


Difference between sap script and report?

277