Answer / Monika Sirohi

To run a script in SQL Developer, follow these steps:
1. Open SQL Developer.
2. Connect to your database.
3. Click on the 'Worksheet' tab.
4. Right-click and select 'New Worksheet'.
5. Paste your SQL script into the new worksheet.
6. Click the 'Run Script' button (or press F9) to execute the script.

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

what is self-join? : Sql dba

1 Answers  

---

what are the authentication modes in sql server? : Sql dba

1 Answers  

---

What is set serveroutput on?

1 Answers  

---

What are the different types of database management systems?

1 Answers  

---

What is the difference between in and between in sql?

1 Answers  

---

What is sql profiler in oracle?

1 Answers  

---

How do I tune a sql query?

1 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---