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

What is pl sql block structure?

974

---

What is sharding in sql?

916

---

Why is pl sql needed?

874

---

What is the difference between clustered and non-clustered index in sql?

957

---

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

1026

---

What is a unique constraint?

1012

---

how do you know if your mysql server is alive? : Sql dba

1025

---

What are inner and outer joins examples of both?

879

---

What is the use of nvl function?

1124

---

What is difference between pls_integer and integer?

908

---

What are all the different normalizations?

970

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1019

---

What is substitution variable in pl sql?

979

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1293

---

Can a foreign key have a different name?

888

---