What is difference between SQL and SQL*PLUS?
Answer / nishi
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database.
SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.
| Is This Answer Correct ? | 0 Yes | 0 No |
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What is a Data File ?
What is save point in oracle database?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is a view and how is it different from a table?
What is cursor
How to view the tablespaces in the current database?
What is a package ? What are the advantages of package ?
Explain the dml?
What is the string concatenation operator in oracle?
How to write date and time literals in oracle?
What is oracle update statement with inner join ?