Answer Posted / 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

what is bdb (berkeleydb)? : Sql dba

672

---

Why functions are used in sql?

620

---

What is delete command in sql?

648

---

what is difference between delete and truncate commands? : Sql dba

680

---

How do you optimize a stored procedure in sql?

582

---

---

What is difference between db2 and sql?

611

---

How do you update sql?

614

---

What is a constraint? Tell me about its various levels.

737

---

Which join is default?

611

---

How to use transactions efficiently : transact sql

653

---

Enlist some predefined exceptions?

693

---

What does select * from mean in sql?

2302

---

What is rownum and rowid?

655

---

What are local and global variables and their differences?

694

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

633

---