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 |
What is a lookup table in oracle?
What is a directory object?
How to delete multiple rows from a table in oracle?
Explain the use of record length option in exp command.
How do you handle duplicate records in a database?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to shutdown your 10g xe server from command line?
What is the use of oracle?
How many memory layers are in the shared pool?
Can objects of the same schema reside in different tablespace?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
what is the use of rank function?