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 |
Mention what is the use of function "module procedure" in pl/sql?
What are string functions in sql?
What are different categories of sql commands?
Does view store data in sql?
what is unique key constraint? : Sql dba
What is the difference between syntax error and runtime error?
what is pragma ?
What is the order of sql select?
What is a data manipulation language?
What is blind sql injection?
what is Complex index. how to create it?
Are there any features that are decommissioned in 11g that are not present in 11g?