diff b/w function and procedure?

9 Answers   iFlex,

---

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

0 Answers  

---

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

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

---

Why do we go for stored procedures?

0 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is the use of primary key?

0 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---