Answer / Prachi Chaudhary

"In PL/SQL, you can bind variables using the following syntax: VARIABLE_NAME := VALUE; For example: v_name := 'John Doe';"

what are all the different normalizations? : Sql dba

1 Answers  

---

What are the different types of tables in sql?

1 Answers  

---

How can you create an empty table from an existing table?

1 Answers  

---

what is a composite key ? : Sql dba

1 Answers  

---

how to shut down the server with 'mysqladmin'? : Sql dba

1 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

Is truncate ddl or dml?

1 Answers  

---

What is normalization in a database?

1 Answers  

---

Why do we use triggers?

1 Answers  

---

how to use myisamchk to check or repair myisam tables? : Sql dba

1 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

How does sql profiler work?

1 Answers  

---