Answer Posted / sudheer kumar mikkilineni

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;

Can we create index on primary key?

911

---

What are functions in sql?

888

---

what is sub-query? : Transact sql

1038

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

987

---

how to delete an existing column in a table? : Sql dba

950

---

Define concurrency control. : Transact sql

1094

---

What is a full join?

911

---

What is file based approach?

874

---

How to add a column ‘salary’ to a table employee_details?

953

---

differentiate between float and double. : Sql dba

988

---

In pl/sql, what is bulk binding, and when/how would it help performance?

936

---

What are the two types of cursors in pl sql?

1001

---

Why stored procedure is faster than query?

946

---

Does sql use python?

972

---

what is the difference between a web-garden and a web-farm? : Sql dba

1009

---