Answer / Shashank Pandey

"In SQL, there are two main types of functions: scalar functions and table functions. Scalar functions return a single value, while table functions return a result set that can be queried like a table. Examples of scalar functions include built-in functions (e.g., LENGTH, SUBSTRING), user-defined functions (UDFs), and system-defined functions. Table functions are used to create reusable queries, which can be used in the SELECT statement as if they were tables."

How do I edit a stored procedure?

1 Answers  

---

What is user in sql?

1 Answers  

---

What is a procedure in pl sql?

1 Answers  

---

what is self join and why is it required? : Sql dba

1 Answers  

---

what is text? : Sql dba

1 Answers  

---

What will you get by the cursor attribute sql%notfound?

1 Answers  

---

What is sqlca in db2?

1 Answers  

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

1 Answers   Microsoft,

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

How do I access sql anywhere database?

1 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

What are the 3 modes of parameter?

1 Answers  

---