What are the attributes of SQL*PLUS ?

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

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is identity column in sql server?

530


What are tables and fields in the database?

554


What is pl sql record in oracle?

565


What is delete command in sql?

558


What is trigger in sql? Explain

538






How many developers work on postgresql?

566


What is the trigger in sql?

539


What is the use of function "module procedure" in pl/sql?

675


how tsql statements can be written and submitted to the database engine? : Transact sql

534


How many sql statements are used?

569


How can you tell the difference between an index and a view?

493


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

603


how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

548


Can we use views in stored procedure?

515


Is left join same as inner join?

539