Is left join and outer join same?
No Answer is Posted For this Question
Be the First to Post Answer
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
Can a commit statement be executed as part of a trigger?
What is a primary key, and how is it different from a unique key?
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
how to write utl file pkg in SQL
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
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?
4 Answers Oracle, TCS, Tecnics,
What is the process of debugging?
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is difference between mysql and postgresql?
How to trace the errors in pl/sql block code?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)