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

How are functions and procedures called in PL/SQL?

1219

---

What is not null in sql?

1053

---

How do you remove duplicates without using distinct in sql?

973

---

What is a schema? How is it useful in sql servers?

1113

---

What is the purpose of normalization?

1038

---

Can we write ddl statements in functions?

1110

---

What are the types of join in sql?

1095

---

How do you declare a variable in pl sql?

1019

---

explain advantages of innodb over myisam. : Sql dba

1124

---

What is pl/sql language case sensitive?

1107

---

what is a composite key ? : Sql dba

1045

---

what are rollup and cube in t-sql? : Transact sql

1094

---

What is meaning of <> in sql?

1065

---

What is aggregate function in sql?

1030

---

What's the difference between a primary key and a clustered index?

984

---