Category: 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.
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.
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.
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
How to write efficient sql – reference article for the new dba
How to write efficient sql – reference article for the new oracle dba
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
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.
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.
dbms_sql examples – complete reference for the new oracle dba
dbms_sql examples – complete reference for the new oracle dba
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…