Answer / Uttam Samajpati

"In SQL and PL/SQL, there are several types of user-defined functions including Scalar functions (return a single value), Table functions (return a table or a cursor), Distinct type functions (return a set of distinct values), and Aggregate functions (used in group by clause)"

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

Is a secondary key the same as a foreign key?

1 Answers  

---

What schema means?

1 Answers  

---

Why procedure is used in sql?

1 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

Write a sql query to convert all character to uppercase after hypen.

1 Answers  

---

how to convert character strings to dates? : Sql dba

1 Answers  

---

Is sqlexception checked or unchecked?

1 Answers  

---

What sql database should I use?

1 Answers  

---

What is the difference between clustered and non-clustered indexes?

1 Answers  

---

How to avoid duplicate records in a query?

1 Answers  

---

What are character functions?

1 Answers  

---