Skip to content

{ Category Archives } sql and plsql

contains info about sql and plsql

How to save Oracle Table data into a text file using UTL_FILE – for the new oracle developer or dba

you are a new oracle dba and you would like to know about a way to write oracle table data into text files using UTL_FILE.

Tagged ,

WEBSERVICE SOAP CALL using PL/SQL and UTL_HTTP – for the new oracle dba or developer

you are a new oracle developer or dba and you would like to know about communicating to a webservice using the utl_http package and pl/sql.This is useful for you to troubleshoot any application functionality using pl/sql and utl_http.

Tagged ,

troubleshooting oracle utl_http package – for the new oracle dba or developer

you are a new oracle developer or dba and you would like to learn about to debug the utl_http package. Below metalink article gives you more info.

Tagged , ,

writing efficient sql -part 2 – for the new oracle dba

writing efficient sql part 2 – from the well know dba jonathan lewis- very good reference article for the new oracle dba

Tagged , ,

How to write efficient sql – reference article for the new dba

How to write efficient sql – reference article for the new oracle dba

Tagged , , , ,

Advanced PL/Sql : Calling Java stored procedures from within oracle PL/SQL-complete reference for the new oracle dba

calling a java stored procedure from oracle PL/SQL- reference for the new oracle dba

Tagged ,

using execute immediate in pl/sql – the new oracle dba reference

If you are a new oracle dba and you want to know how to use the execute immediate command , then you have the complete reference in below article.

Tagged , , , ,

using exception handling in pl/sql – the new oracle dba reference

The new oracle dba can fine here an example of using exception handling in pl/sql blocks.

Tagged , , ,

dbms_sql examples – complete reference for the new oracle dba

dbms_sql examples – complete reference for the new oracle dba

Tagged , , ,

why is sql important for a new oracle dba career?

Why is sql important for a new dba? A new oracle dba should know sql because of the following reasons 1)All applications connect to the oracle database and run sql statements either to update the database or insert new data into the database or to bring back data from the database.in case any sql statement […]

Tagged , , ,