What are the key differences between SQL and PL SQL?
No Answer is Posted For this Question
Be the First to Post Answer
What operators deal with null?
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
What is the Difference between Procedure and Function.Can we call a Function in a DML?
what is the difference between join and union? : Sql dba
What is a sql*loader control file?
What is sql table?
what is uncommittable transactions? : Transact sql
What is the maximum number of columns in sql table?
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
What is sql basics?
Is left join inner or outer by default?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution