What are different types of statements supported by sql?

0 Answers  

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

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  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

What are the various levels of constraints?

0 Answers  

---

What are the sql versions?

0 Answers  

---

What is a primary key example?

0 Answers  

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

How do you respond to dementia behavior?

0 Answers  

---