Answer Posted / shanmukha srinivas

procedure can run in sql block like
begin
sp_procedure_name(input parameters);
end;
function can run in sql block like
select sf_function_name(input paramters)

what does myisamchk do? : Sql dba

961

---

Which data type is a composite type?

931

---

how to get a list of all tables in a database? : Sql dba

914

---

What is sqlcommand?

962

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

930

---

what are tables and fields? : Sql dba

987

---

discuss about myisam key cache. : Sql dba

973

---

List and explain the different types of join clauses supported in ansi-standard sql?

1299

---

Explain the structure of pl/sql in brief.

1040

---

What are the different schemas objects that can be created using pl/sql?

965

---

Is a table valued function object?

958

---

What is clause?

1062

---

How can we avoid duplicating records in a query?

917

---

Why functions are used in sql?

918

---

What is rename in sql?

915

---