Is PL / SQL a language to learn if you have Oracle 11g?

Question

is Oracle 11g PL / SQL? Is there any other langauge that uses Oracle? I do not mean end-user applications that use other languages ​​only if I'm directly in the database. I ask because I know that SQL Server will allow you to use different .NET languages ​​and does not know if Oracle has anything other than pl / sql.

Thanks.

EDIT: I just want to make sure pl / sql is not dead or something else. I would not want to study it and build it in a database with it, and someone said ... well, you should have used .... x.

Answer 1

For the most part, I think the answer is "Yes." I think it is also possible to load Java and C modules so that they can be called / called by the PL / SQL code in the database, but I myself have never seen this. I don’t know where to look for information about this, but now you have other studies :)

An example of a Java stored procedure: http://www.developer.com/db/article.php/3337411/Oracle-and-Java-Stored-Procedures.htm

..and don’t worry that PL / SQL is dead or dying. I think this is still the way most stored procedures and code in the database are written for Oracle.

Answer 2

From Oracle:

PL / SQL is a true 3GL that was developed specifically for seamless processing of SQL statements. It provides special syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL / SQL is stored and compiled into an Oracle database and runs into an Oracle executable. It automatically inherits the reliability, security, and portability of the Oracle database.

http://www.oracle.com/technetwork/database/features/plsql/index.html

Answer 3

Accepting the information at the following link:
1 Introduction to Oracle Database Extensions for .NET

Bring me that I have never used the CLR extensions, even with SQL Server, so I cannot provide any further assistance. I just think that the information provided by this link is related and can provide useful advice.

Answer 4

PL / SQL is very good for executing a large amount of DML in a stored procedure. If you use forms and reports, then this is also the language of choice. The disadvantage is that it is not portable and does not interact very well with many libraries available for other environments. I do most of my hard work with the database in PL / SQL, but all the web applications and things that other systems need to integrate using J2EE and JDBC.