Answer / Arti Pal

In SQL, you can use the following command to get a list of all tables in a specific database. Replace `database_name` with the name of your database and `information_schema` with the name of the system database.nn```sqlnSELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'database_name';n```

Can a procedure in a package be overloaded?

1 Answers   EXL,

---

In what condition is it good to disable a trigger?

1 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

What are the features of pl sql?

1 Answers  

---

how to get a list of columns in an existing table? : Sql dba

1 Answers  

---

what is uncommittable transactions? : Transact sql

1 Answers  

---

What is the difference between row level and statement level trigger?

1 Answers  

---

What mean sql?

1 Answers  

---

Can we insert delete data in view?

1 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

How do you rename a table in sql?

1 Answers  

---

what is sp_pkeys? : Transact sql

1 Answers  

---