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.

Can we insert data in view?

971

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1152

---

Does pl sql work in mysql?

987

---

What is the difference between local variables and global variables?

1128

---

Explain the advantages and disadvantages of stored procedure?

1153

---

what is rdbms? : Sql dba

1018

---

Explain ttitle and btitle.

1124

---

What is a system versioned table?

997

---

What are sql functions? Describe in brief different types of sql functions?

1106

---

Does postgresql run on the cloud?

1154

---

What is sql deadlock?

1149

---

How to prepare for oracle pl sql certification?

1074

---

Explain the methods used to protect source code of pl/sql.

1029

---

What does over partition by mean in sql?

985

---

What if we write return in procedure?

1433

---