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 |
What is bulk compiling in pl/sql.?
what is 'mysqlshow'? : Sql dba
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
how to use case expression? : Sql dba
how to create a test table in your mysql server? : Sql dba
What is audit logout in sql profiler?
What are the types of index in sql?
How do you truncate?
How can one get sql*loader to commit only at the end of the load file? : aql loader
How do I view stored procedures?
please explain database architecture..
What is package in pl sql with an examples?
Oracle (3259)
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)