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 is difference between nchar and nvarchar?

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

How do I find duplicates in a single column in sql?

0 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

Is sql a dbms?

0 Answers  

---

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

what is definer rights invoke rights?

1 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

What are views in sql?

0 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

How do you update a table in sql?

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---