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 is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

560

---

How exception is different from error?

558

---

what is the difference between join and union? : Sql dba

558

---

What is sqlexception in java?

555

---

What is data control language (dcl)?

611

---

---

What is rollback?

595

---

Are subqueries faster than joins?

581

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

656

---

How to look at the current sql*plus system settings?

614

---

What is the use of index in sql?

571

---

What is a primary key example?

526

---

write an sql query to find names of employee start with 'a'? : Sql dba

592

---

Is like operator in sql case sensitive?

519

---

how can we destroy the cookie? : Sql dba

569

---

What is nosql vs sql?

584

---