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.

Which is faster truncate or drop?

0 Answers  

---

What is %s in sql?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

What is pivot in sql?

0 Answers  

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

How can get second highest salary in sql?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

What is varchar example?

0 Answers  

---

Why do we need view in sql?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

What is basic structure of pl sql?

0 Answers  

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

---