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 On6 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*loader1 5020
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently1 5204
I want to execute a piece of code before calling a procedure. How to achieve it?1 2626
How long does startup repair take in windows 7?
How to rename a table in DB2 ?
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
Explain the overview of hadoop history breifly?
what is meant by power and distribution transformer ?
What is the purpose of the analyzer in petrochemical plant?
What are the most commonly defined input formats in Hadoop?
What is jdbc and odbc in java?
What oracle weblogic server includes?
Explain binding instances?
Mention some types of transformation?
Is there any relevant technique to produce power from light and heat energy of the sun simultaneosly from same rays of light?
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)
Can an mdb be a message producer or both a producer and consumer? : BEA Weblogic
Difference between sap script and report?