Answer / Rajesh Tejan

Functions can be called using the function name followed by parentheses, while passing any required arguments. Procedures are called using the PROCEDURE name, followed by parentheses containing any required arguments enclosed within IS keyword (if any). For example:ntFUNCTION MyFunction(p1 NUMBER) RETURN VARCHAR2 IS ... END; ntPROCEDURE MyProcedure(p1 IN NUMBER) IS ... END; nntBEGINnttMyFunction(1);nttMyProcedure(1);ntEND;

What is the command used to fetch the first 5 characters of a string?

1 Answers  

---

how can we destroy the cookie? : Sql dba

1 Answers  

---

What is an implicit commit?

1 Answers  

---

What is data definition language?

1 Answers  

---

who introduced sql?

1 Answers  

---

What is sqlerrm?

1 Answers  

---

How do you use join?

1 Answers  

---

What is %type in pl sql?

1 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

what is sp_pkeys? : Transact sql

1 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---