Answer / siddiq

In oracle joins, there is no need to mention the words like
left outer join, right outer join, etc..
Oracle joins sql joins
-------------------------------------------------
self join Natural join
cross join Arbitary join
outer join Left outer join
Equi join Right outer join
Non Equi join Full outer join

In sql server we have to use the words(join) in the query.

Answer / uma

i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN

Answer / veereshkethari

I'm not happy with Uma answer,anybody can explain?please

Explain the PL/SQL compilation process.

3 Answers  

---

What is the use of pl/sql table?

0 Answers  

---

Can I call a procedure inside a function?

0 Answers  

---

What does the argument [or replace] do?

0 Answers  

---

what are the nonstandard string types? : Sql dba

0 Answers  

---

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

full outer join syntax

5 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

What is difference between stored function and application function?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

How to fetch alternate records from a table?

0 Answers  

---