Answer Posted / sudheer kumar mikkilineni

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

How many types of cursors supported in pl/sql?

794

---

Is a table valued function object?

759

---

what are the 'mysql' command line options? : Sql dba

743

---

What is pivot table in sql?

739

---

What operating systems are supported by oracle sql developer?

714

---

---

How do I tune a sql query?

725

---

Can a table contain multiple primary key’s?

806

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

766

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

722

---

Can a composite key be null?

713

---

how to create a new view in mysql? : Sql dba

685

---

Could you please provide oca (oracle 10g) dumps for my certification ?

4782

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

719

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

704

---

how to enter numeric values as hex numbers? : Sql dba

770

---