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 |
Can we connect to postgresql using sql developer?
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
select 1,col1,col2 from table1. output?
What are the types of triggers in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
Write the alter statement to enable all the triggers on the t.students table.
What is difference between hql and native sql?
How to change sql*plus system settings?
Does access use sql?
Is sql a scripting language?