| query [message #51567] |
Thu, 30 May 2002 21:58  |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
differentiate SQL,PL SQL,Vs Oracle.
DBMS Vs RDBMS.
|
|
|
|
| Re: query [message #51577 is a reply to message #51567] |
Fri, 31 May 2002 08:04  |
Krishnan
Messages: 18
Registered: October 2000
|
Junior Member |
|
|
SQL is one liner and called as structured query language. Ofcourse a line could be as long as pages depending on the complexity of the query.
PL/SQL -- If something cannot be achieved in SQL and you need some programming method like if, Loop then you go in for PL/SQL which evidently means that they are more than one lines and should be enclosed between a begin and end
DBMS -- Anything related with in a table. If you have to achieve a relation between tables you need to achieve it through programs and procedure.
RDBMS - Anything related within as well as between tables. With more standards i.e. DBMS combined with relational standards makes your life easier as you needn't code to achieve data integrity.
This is the basic difference but there are many more
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
