Interested to Buy Any Domain ? << Click Here >> for more details...
What are the attributes of SQL*PLUS ?
- 2 Answers
- 10328 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 |
How to avoid using cursors?
List the different type of joins?
What does count (*) do in sql?
Are left and right joins the same?
Which is faster view or stored procedure?
PL/SQL allocates memory for the variable's at runtime or at compile time
What is pragma in sql?
what is the command for user data type?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
what is union, minus and interact commands? : Sql dba
Is crud a cuss word?
What is the difference between union and union all command?
-
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)
