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
What is sql trigger example?
What problem one might face while writing log information to a data-base table in pl/sql?
Can we create view in stored procedure?
How to run pl/sql statements in sql*plus?
What are the types of operators available in sql?
How do I pipe the output of one isql to another?
what are the differences between require and include, include_once and require_once? : Sql dba
What are different clauses used in sql?
Define tables and fields in a database
How to write html code in pl sql?
which operator is used in query for pattern matching? : Sql dba
Can variables be used in sql statements?
What is view? Can we update view
Do prepared statements prevent sql injection?
what are different types of keys in sql?