Results 1 to 2 of 2

Thread: Difference in SQL,*PLUS and PL/SQL

  1. #1
    RogersNguyen is offline Senior Member
    Join Date
    Dec 2009
    Posts
    227
    Rep Power
    3

    Default Difference in SQL,*PLUS and PL/SQL

    I am new in programming word. There are There are three terms, SQL,PL/SQL,SQL*PLUS. I want to know the difference between these terms.As we use both SQL and PL/SQL on same prompt then what are the differences in functionality of both.any suggestion would be highly appreciated.

  2. #2
    MorganCooper is offline Senior Member
    Join Date
    Dec 2009
    Posts
    233
    Rep Power
    3

    Default

    SQL was developed at IBM and initially called as SEQUEL.it is also called as Structure Query Language.it is used to query on Relational database,You can make queries on different objects of the database and you can create also according to the limitation and scope of database.

    It has been taken over by one different giant organizations,ISO( International standards Organization) and ANSI(American National Standards Institute).It is the base of database and whenever you run SELECT,CREATE,UPDATE, DELETE commands are the part of SQL.

    The PL/SQL is a procedural language which is used to generate the procedures and function of oracle database. You can access the information from database server using intricate operation.The operations can be run in an application.

    The different tools of oracle database gives the advantage to genrate the application using this language.You can change the behavior of errors during database access using of exception method and block.

Similar Threads

  1. Difference between C and C++
    By GonzalezBrown in forum Programming
    Replies: 2
    Last Post: 06-24-2010, 11:05 AM
  2. What is the difference between C and C ++?
    By GonzalezBrown in forum Programming
    Replies: 3
    Last Post: 06-07-2010, 04:43 PM
  3. Difference Servlet & ASP
    By MartinWilson in forum Programming
    Replies: 2
    Last Post: 02-06-2010, 11:23 AM
  4. Difference in RAM and ROM
    By PerrySullivan in forum Motherboard
    Replies: 3
    Last Post: 02-01-2010, 02:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
SEO by SubmitEdge

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48