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.

what are the security recommendations while using mysql? : Sql dba

0 Answers  

---

What is primary and foreign key?

0 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

how to use like conditions? : Sql dba

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

---

What are the events on which a database trigger can be based?

0 Answers  

---

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

---

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

0 Answers  

---

How to revise and re-run the last sql command?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

What is the purpose of primary key?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---