What is difference between SQL and SQL*PLUS?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a package ? What are the advantages of package ?

832


What is recovery manager(rman) backup in Oracle?

891


How translate command is different from replace?

749


Explain what are the different type of segments?

752


What are the major difference between truncate and delete?

745


How to write date and time interval literals in oracle?

767


what are the advantages of running a database in archive log mode?

1950


What do you mean by a tablespace?

779


Explain rename?

741


How to divide query output into groups in oracle?

751


How would you best determine why your MVIEW couldnt FAST REFRESH?

1631


How to define a procedure inside another procedure?

757


what is a Nested Loop join?

1803


How to load data from external tables to regular tables?

807


What is an oracle wallet?

679