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.

Can you call pl/sql package functions from within a fast formula?

0 Answers  

---

What is normalization in sql?

0 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

Explain raise_application_error.

0 Answers  

---

Is postgresql a server?

0 Answers  

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

What are the most important ddl statements in sql?

0 Answers  

---

What is dml with example?

0 Answers  

---

What is sql profiler in oracle?

0 Answers  

---

What is the size of partition table?

0 Answers  

---

Is pl sql useful?

0 Answers  

---