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 the difference between Union and Union all. Which is faster.

0 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

Explain constraints in sql?

0 Answers  

---

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

What is a schema in sql?

1 Answers  

---

Is t sql a programming language?

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

How do you respond to dementia behavior?

0 Answers  

---