How can I optimize this dynamic SQL query in oracle with PL/SQL?

What is the difference between SQL, Oracle SQL and PL/SQL? Which is easier?

• Answer:

  ORACLE ---------- * It is a software package, that is used to handle or to maintaine the databse. * It is a software to give the structure of database storage. * Oracle 7, Oralce 8, Oracle 8i, Oracle 9i, Oracle 11i are available in market. * It is a company called" Oracle " to produce this software. SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Unfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others). PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. Typically, each block performs a logical action in he program. Oracle can invoke a PL/SQL program by placing it in the SQLPLUS. PL/SQL's language syntax, structure and data types are similar to that of ADA. The PL/SQL language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance). PL/SQL is commonly used to write data-centric programs to manipulate data in an Oracle database. the best is ORACLE as it is platform dependant and can run in UNIX and windows. whereas SQL only can run in windows. easiest? i would say that, if you know SQL, it would be easy to know Oracle as Oracle is just an expansion of SQL.