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 sql performance tuning?

0 Answers  

---

List the different type of joins?

0 Answers  

---

what are the join types in tsql? : Transact sql

0 Answers  

---

Explain correlated query work?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

What is scalar function in sql?

0 Answers  

---

What does trigger mean in psychology?

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

How pl/sql source code can be protected?

3 Answers  

---