What are the attributes of SQL*PLUS ?
Answers were Sorted based on User's Feedback
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 |
Answer / pushkar
1. /SQL*Plus commands are used to manipulate data in tables.
2. /SQL*Plus commands manipulate table definitions in the
database.
| Is This Answer Correct ? | 5 Yes | 8 No |
How can I delete duplicate rows?
Is sql an operating system?
Can you create a table with Primary Key not as the clustered index.
Why plvtab is considered as the easiest way to access the pl/sql table?
what is a control file ? : Sql dba
what are the disadvantages of mysql? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the different between Stored Procedure and Procedure?
how do you login to mysql using unix shell? : Sql dba
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Why do we use procedures in pl sql?
how view used for security purposes?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)