Interested to Buy Any Domain ? << Click Here >> for more details...
What are the attributes of SQL*PLUS ?
- 2 Answers
- 10463 Views
- Dream Careers, Oracle, I also Faced
- E-Mail Answers
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 #table in sql?
how many columns can be used for creating index? : Sql dba
What are the usages of sql?
how to add a new column to an existing table in mysql? : Sql dba
What is sqlite used for?
How do sql databases work?
What is the location of pre_defined_functions.
What are user defined functions?
Enlist the data types that can be used in pl/sql?
how would concatenate strings in mysql? : Sql dba
Explain what is a field in a database and record in a database?
why we use nocopy?
-
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)
