Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SQL and SQL*PLUS?
- 1 Answers
- 2836 Views
- I also Faced
- E-Mail Answers
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 |
How are Indexes Update ?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the usage of synonyms?
how to get count of tables in particular database in Oracle?
Explain about functional dependency and its relation with table design?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Is a rollback possible to any savepoint?
How to assign a table row to a record variable?
Explain enable novalidate constraint.
Where do we use decode and case statements?
How to write a left outer join with the where clause in oracle?
Oracle General 
