Answer / Shiv Shkti Singh

To get a list of all tables in a MySQL database, you can use the following SQL command:nnSELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';

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

1 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

What is scope of pl sql developer in future?

1 Answers  

---

what are the advantages of mysql in comparison to oracle? : Sql dba

1 Answers  

---

What do you mean by rowid?

1 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

What is a table?

1 Answers  

---

What is procedure and function?

1 Answers  

---

What does partition by mean in sql?

1 Answers  

---

What is the reports view in oracle sql developer?

1 Answers  

---

How to write html code in pl sql?

1 Answers  

---

What are field types?

1 Answers  

---