0
Disadvantages of Oracle PLSQL
If you're just running Oracle databases, there are no major disadvantages to using PL/SQL as long as you're aware of its limitations.
Proprietary to Oracle
PL/SQL is proprietary to Oracle which means if you were to change database vendors then you would have to re-write all your Oracle PL/SQL programs. Also if you use a mixture of databases or develop applications to run on different databases, you will either have to support lots of source code or write your applications in a database-neutral language like Java, VB or C and use the APIs to access the database.
Poor I/O Features
The other limitation of Oracle PL/SQL is that there is very little support for i/o either to read/write files or to read from or write to a user interface. The rationale behind this is that PLSQL is designed for manipulating information from the database and not for processing files or communicating with users. These operations are possible - they just require a little bit more effort!
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What are the disadvantages of decimals?
None, there are no disadvantages.
What are the disadvantages of math?
Zelch, None. There are no disadvantages to learning math.
What are advantages and disadvantages of paradox?
Advantages can become disadvantages. Sometimes the disadvantages become the advantage. So, who's to say if it was an advantage or a disadvantage?
What are the disadvantages and disadvantages of least square method?
The disadvantages are that the calculations required are not simple and that the method assumes that the same linear relationship is applicable across the whole data range. And these are the disadvantages of the least squares method.
What are disadvantages of mathematics?
Only a person who does not understand mathematics is disadvantaged. Mathematics in itself has no disadvantages.
Why decode is not used in plsql?
Decode can be used in PLSQL, but in version 9i and later the case statement is easier to use, more powerful and more intuitive.
Plsql procedures and functions?
Are really important in an Oracle Database.
Is it possible to change the structure of existing view if yes then how?
using plsql sql
What is the maximum number of handlers processed before the PLSQL block is exited when an exception occurs?
only one
Which is an example of a PLSQL subprogram?
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
How do you compile a PLSQL procedure?
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
What are stored procedures in data bases?
Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement
Where can I download the book Oracle Jdeveloper 10g for Forms and PLSQL Developers by Peter Koletzke and Duncan Mills?
i cant download from ...any where
What is PLSQL?
The Oracle Corporation's application development language is PL/SQL. It is a superset of SQL that uses standard programming-language to supplement the SQL. PL/SQL stands for Procedural Language/Structured Query Language.
What are the disadvantages and disadvantages of hydroelectricity?
advantages : electricity disadvantages: no electricity
What are disadvantages and disadvantages of autocracy?
what are some advantages and disadvantages of dictatorship
What are the disadvantages for disadvantages?
gramophone
