Explain the purpose of %type and %rowtype data types?

0 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

What is data manipulation language?

0 Answers  

---

What is a table in a database?

0 Answers  

---

---

What is a subquery in sql?

0 Answers  

---

Can I create table without primary key?

0 Answers  

---

What are the advantages of sql?

0 Answers  

---

What are all types of user defined functions?

0 Answers  

---

What are different categories of sql commands?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---