Answer Posted / selvaraj anna university coe

SQL> SELECT 1,emp_no,emp_name FROM emp;

1 EMP_NO EMP_NAME
--------- --------- -------------------------
1 100 SELVA
1 101 RAJ
1 102 A S KALA
1 103 JESLIN FANTA MALAR
1 104 ANITA
1 105 MURUGU
1 106 SRIVATSAN
1 107 SARABOOT
1 108 KARTHI SIR
1 109 SUDHA
1 110 MERCHI
1 111 SAVI

12 rows selected.

What is a sql instance vs database?

570

---

Which is faster union or join?

487

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2567

---

What is java sql driver?

539

---

How do I make my sql query run faster?

462

---

---

What are the two parts of design view?

577

---

What does inner join mean?

550

---

How do I run a pl sql procedure in sql developer?

507

---

How do I view tables in sql developer?

510

---

What is trigger with example?

560

---

What pl/sql package consists of?

633

---

How do you write a subquery?

517

---

What is compilation error in pl sql?

502

---

What is cte sql?

513

---

How do you remove duplicates without using distinct in sql?

499

---