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

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is fmtonly in sql?

0 Answers  

---

List the various privileges that a user can grant to another user?

0 Answers  

---

What are the indexing methods?

0 Answers  

---

---

what is a record in a database ? : Sql dba

0 Answers  

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

What is acid property in a database?

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

How to select 10 records from a table?

0 Answers  

---

what is dbms? : Sql dba

0 Answers  

---