What is natural join in sql?

0 Answers  

---

How do I remove all records from a table?

0 Answers  

---

can i write pl/sql code in a package

2 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

What is the usage of sql functions?

0 Answers  

---

What are inbuilt functions in sql?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

Why use triggers in sql?

0 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

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,

---

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,

---