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 the difference between sharding and partitioning?
Explain oracle instance.
How to create a stored function in oracle?
Explain about integrity constraint?
12 RULES OF RDBMS
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Whats the benefit of dbms_stats over analyze?
What do you understand by a database object? Can you list a few of them?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
When a form is invoked with call_form, Does oracle forms issues a save point ?
How to change system global area (sga) in oracle?