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 stored procedures and application procedures?

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

What is sql analyzer?

0 Answers  

---

What is difference between db2 and sql?

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---

---

What is embedded sql with example?

0 Answers  

---

How can I get the number of records affected by a stored procedure?

0 Answers  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

What is a field in a database?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Is microsoft sql free?

0 Answers  

---