Answer / chandra shekhar

Dear Pushkar, SQL*PLUS commands are not used to manipulate the data in tables. Its DML commands in SQL are used to manipulate the date in the table like INSERT, UPDATE, DELETE, MERGE.

Table definition commands comes under DDL commands like CREATE, ALTER, DROP, TRUNCATE.

Some of the Attributes of SQL*PLUS commands are
1. It need not be terminated by semi colon
2. It can be abbreviated
Eg:- DESCRIBE can be written as DESC
APPEND can be written as a
RUN can be written as r

regards
j

Answer / pushkar

1. /SQL*Plus commands are used to manipulate data in tables.
2. /SQL*Plus commands manipulate table definitions in the
database.

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

0 Answers  

---

What are hotfixes and patches?

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

What are the constraints available in sql?

0 Answers  

---

What are the different datatypes available in PL/SQL?

0 Answers  

---

how do you know the version of your mysql server? : Sql dba

0 Answers  

---

Define union, minus, union all, intersect ?

0 Answers  

---

Is left join inner or outer by default?

0 Answers  

---

What is a mutating table and a constraining table?

0 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

What does count (*) mean?

0 Answers  

---