Hi Phanindra,
You might have already realized by now that the two are different. So if i wanna add some think to this discussion i will put it this way.
SQL Structured Query Language (ANSI Standards)
SQL *Plus Envoirnment (Oracle Tool)
Differences:
1. SQL A language while SQL*Plus An environment
2. SQL ANSI standard while SQL*Plus Oracle proprietary
3. IN SQL Keyword cannot be abbreviated while in SQL*Plus Keywords can be abbreviated
4. IN SQL Commands do not allow manipulation of values in the database while in SQL*Plus Commands do not allow manipulation of values in the database
Hope this a helpful. Thank you.
BIkash.
Reference: http://www.experts-exchange.com/Databases/Oracle/Q_21532391.html
------------------------------------------------------------ Message no. 6365[Branch from no. 6314] Posted by Bikash Adhikari (badhikari) on Tuesday, February 7, 2006 11:12pm Subject: Re: SQL quick referenceA very helpful link Gwen. Thank you very much.
BIkash
------------------------------------------------------------ Message no. 6367[Branch from no. 6314] Posted by Harold Harris (hjharris2) on Tuesday, February 7, 2006 11:29pm Subject: Re: SQL quick reference Gwen, Thanks for sharing that information. It's been very helpful. HH ------------------------------------------------------------ Message no. 6371[Branch from no. 6314] Posted by Venkat Munagala (vrmunagala) on Wednesday, February 8, 2006 1:54pm Subject: Re: SQL quick reference Hi Gwen The link is very informative. This gives a great knowledge on accessing databases, formatting Query results and PL/SQL commands. Rohit ------------------------------------------------------------ Message no. 6374[Branch from no. 6314] Posted by Phanindra Maddhi (pmaddhi) on Wednesday, February 8, 2006 3:23pm Subject: Re: SQL quick reference Thanks for sending. It is really helpful ------------------------------------------------------------ Message no. 6380[Branch from no. 6354] Posted by Alex Auffenorde (aaauffenorde) on Thursday, February 9, 2006 12:56am Subject: Re: Project III Yes you can use SQL to put all of those commands into one script. Then run that script to get the end result required by Dr. Liu for Project III. Good luck Alex ------------------------------------------------------------ Message no. 6381[Branch from no. 6380] Posted by Rhonda Nichols (renichols2) on Thursday, February 9, 2006 8:42am Subject: Re: Project III I also agree. The assignment was to build 1 query with subquery commands to find the end result of 11 records. -Rhonda Nichols ------------------------------------------------------------ Message no. 6385[Branch from no. 6266] Posted by Krupa Kandavalli (kkandavalli) on Thursday, February 9, 2006 3:19pm Subject: Re: SQL SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface. There is also the SQL*Plus Instant Client which is a stand-alone command-line interface available on platforms that support the OCI Instant Client. SQL*Plus Instant Client connects to any available Oracle database, but does not require its own Oracle database installation. SQL*Plus has its own commands and environment, and it provides access to the Oracle Database. It enables you to enter and execute SQL, PL/SQL, SQL*Plus and operating system commands to perform the following: 1) Format, perform calculations on, store, and print from query results 2) Examine table and object definitions 3) Develop and run batch scripts 4) Perform database administration You can use SQL*Plus to generate reports interactively, to generate reports as batch processes, and to output the results to text file, to screen, or to HTML file for browsing on the Internet. You can generate reports dynamically using the HTML output facility of SQL*Plus, or using the dynamic reporting capability of iSQL*Plus to run a script from a web page. ------------------------------------------------------------ Message no. 6393[Branch from no. 6266] Posted by Kelsey Pooley (kjpooley) on Thursday, February 9, 2006 11:09pm Subject: Re: SQL SQL Plus is the interface to use SQL. In simplest terms, when you open SQL Plus, it opens a window where you can enter your SQL commands, just as Microsoft Word gives you a blank page to start typing a paper. ------------------------------------------------------------ Message no. 6399[Branch from no. 6314] Posted by Imran Pathan (ipathan) on Friday, February 10, 2006 6:27am Subject: Re: SQL quick reference Thank you for the link Gwen Imran ------------------------------------------------------------ Message no. 6401[Branch from no. 6314] Posted by Imran Pathan (ipathan) on Friday, February 10, 2006 6:34am Subject: Re: SQL quick reference Top Ten ways things would be different if Microsoft built cars: 1. A Particular model year of car wouldn't be available until AFTER that year, instead of before. 2. Every time they repainted the lines on the road, you'd have to buy a new car. 3. Occassionally your car would just die for no reason and you'd have to restart it. For some strange reason, you would just accept this. 4. You could only have one person at a time in your car, unless you bought a car '95 or a car NT, but then you would have to buy more seats. 5. You would be constantly pressured to upgrade your car. Wait a second, it's that way NOW! 6. Sun Microsystems would make a car that was solar powered, twice as reliable, 5 times as fast, but only ran on 5% of the roads. 7. The oil, alternator, gas, and engine warning lights would be replaced with a single "General Car Fault" warning light. 8. People would get excited about thew new features in Microsoft cars, forgetting completely that they had been available in other brands for years. 9. We'd all have to switch to Microsoft Gas (tm). 10. Ford, General Motors, and Chrylser would all be complaining because Microsoft was putting radios in all its models. Imran ------------------------------------------------------------ Message no. 6403[Branch from no. 6266] Posted by Swarna Bangaru (sbangaru) on Friday, February 10, 2006 12:07pm Subject: Re: SQL SQL is a language to query database, SQL*Plus is a tool. ------------------------------------------------------------ Message no. 6406[Branch from no. 6266] Posted by Venkat Munagala (vrmunagala) on Friday, February 10, 2006 1:23pm Subject: Re: SQL Hi phanindra, Here is some more information about SQL*PLUS. SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface. SQL*Plus has its own commands and environment, and it provides access to the Oracle Database. It enables us to enter and execute SQL, PL/SQL, SQL*Plus and operating system commands to perform the following: Format, perform calculations on, store, and print from query results Examine table and object definitions Develop and run batch scripts Perform database administration we can use SQL*Plus to generate reports interactively, to generate reports as batch processes, and to output the results to text file, to screen, or to HTML file for browsing on the Internet. You can generate reports dynamically using the HTML output facility of SQL*Plus, or using the dynamic reporting capability of iSQL*Plus to run a script from a web page. Rohit ------------------------------------------------------------ Message no. 6407[Branch from no. 6385] Posted by Krupa Kandavalli (kkandavalli) on Friday, February 10, 2006 1:41pm Subject: Re: SQL Hi Phani, I forgot to post the source for my last posting, here it is http://download- east.oracle.com/docs/cd/B19306_01/server.102/b14357/qstart.htm#i1056581 ------------------------------------------------------------ Message no. 6408[Branch from no. 6401] Posted by Gnaneshwar Bukka (gbukka) on Friday, February 10, 2006 3:25pm Subject: Re: SQL quick reference Kool one imran.....it seems like the guy who worte this doesnt like MS.....have fun.. Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 6409[Branch from no. 6337] Posted by Gwendolyn Mobley (gdmobley) on Saturday, February 11, 2006 2:02am Subject: Re: SQL Rhonda, the SQL and SQL*Plus are the same, as indicated by the ISO standard. However, SQL*Plus has Oracle specific features meaning there are some features for SQL you couldn't use for a relational database such as Access. Gwen ------------------------------------------------------------ Message no. 6410[Branch from no. 6403] Posted by Gwendolyn Mobley (gdmobley) on Saturday, February 11, 2006 2:06am Subject: Re: SQL SQL is also a tool, as most programming languages are. Gwen ------------------------------------------------------------ Message no. 6414[Branch from no. 6401] Posted by Imran Pathan (ipathan) on Saturday, February 11, 2006 5:18am Subject: Re: SQL quick reference Funny program class softwareProfessional { private: double salary; long lunches; float jobs; char unstable; void work; private: updateSkills(); downloadPictures(); processH1(); getVisa(); submitResignation(); public: paintTheManagers(); fTP(); /* Don't be confused with */ /* "file transfer protocol" */ /* It actually means Full Time Pass */ sendMails(); receiveMails(); send(Pictures); send(Jokes); recv(Pictures); recv(Jokes); }; ------------------------------------------------------------ Message no. 6415 Posted by Waseem Manzoor (wmanzoor) on Saturday, February 11, 2006 11:39am Subject: Primery Key? Any body can explain me please the difference between a primery key and unique key? Waseem Manzoor ------------------------------------------------------------ Message no. 6418[Branch from no. 6415] Posted by Rohini Shrestha (rshrestha) on Saturday, February 11, 2006 12:07pm Subject: Re: Primery Key? Hi Wassem, A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. I think there isn't any key named unique key. However, there is unique integrity constraints. Integrity constraints provide a mechanism for ensuring that data comforms to guidelines specified by the database administrator and UNIQUE integrity constraints is typically enforced using a UNIQUE index. Hope this helps. Rohini ------------------------------------------------------------ Message no. 6424[Branch from no. 6314] Posted by Kelli Lemon (kmlemon) on Saturday, February 11, 2006 1:12pm Subject: Re: SQL quick reference Thanks for that reference Gwen. Kelli ------------------------------------------------------------ Message no. 6425[Branch from no. 6418] Posted by Muhammad Latif (mlatif) on Saturday, February 11, 2006 3:36pm Subject: Re: Primery Key? Hey Waseem, Major difference between primary and unique key is that, primary key doesn't allow NULLs, but unique key allows NULL once. Arsal ------------------------------------------------------------ Message no. 6426[Branch from no. 6415] Posted by Krishnamurth Ashwini (kashwini) on Saturday, February 11, 2006 3:39pm Subject: Re: Primery Key? Primary Key: A column in a table whose values uniquely identify the rows in the table. A primary key value cannot be NULL. Unique Key: Unique Keys are used to uniquely identify each row in an Oracle table. There can be one and only one row for each unique key value. Example: Consider a table of citizen names that contains(among others), two fields: SSN number and Tax ID. These two are different for different people and can never be the same. So these two fields can be considered unique keys in a table. But, When you pick a primary key from a table, you can pick any one of these unique keys as a primary key. If there is no unique key in a table, combination of fields can form a "composite" primary key. In theory, you can have a table with no unique keys, but can still have a primary key. Ash ------------------------------------------------------------ Message no. 6427[Branch from no. 6415] Posted by Waseem Manzoor (wmanzoor) on Saturday, February 11, 2006 3:44pm Subject: Re: Primery Key? Hey guyz thanks for the ans The other major difference that I found through research is primary key creates a clustered index on the column, where as unique key creates a nonclustered index by default. Waseem manzoor ------------------------------------------------------------ Message no. 6434[Branch from no. 6415] Posted by Bikash Adhikari (badhikari) on Sunday, February 12, 2006 4:24pm Subject: Re: Primery Key?Hay Waseem as most of the friends have already mentioned the primary differences between primary key and unique key are:
1. unique key constraint can be created over columns with null values, while a primary key constraint does not allow null values, and the other one being,
2. there can only be one primary key constraint defined on a table, but there can be multiple unique key constraints defined on a table.
Thank you.
Bikash
------------------------------------------------------------ Message no. 7381[Branch from no. 6406] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 9:20pm Subject: Re: SQL SQL (commonly expanded to Structured Query Language — see History for the term's derivation) is the most popular computer language used to create, modify and retrieve data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI/ISO standard. SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database. Abhash ------------------------------------------------------------ Message no. 7382[Branch from no. 6424] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 9:24pm Subject: Re: SQL quick reference Thanx for sharing these good stuff guys Abhash ------------------------------------------------------------ Message no. 7383[Branch from no. 6434] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 9:29pm Subject: Re: Primery Key? A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. A unique constraint is a single field or combination of fields that uniquely defines a record. Some of the fields can contain null values as long as the combination of values is unique. A good difference is that none of the fields that are part of the primary key can contain a null value. Some of the fields that are part of the unique constraint can contain null values as long as the combination of values is unique. Abhash ------------------------------------------------------------