45 Useful Oracle Queries
Here’s a list of 40+ Useful Oracle queries that every Oracle developer must bookmark. These queries range from date manipulation, getting server info, get execution status, calculate database size etc. Date / Time related...
PL-SQL Tutorials, Tips & Tricks
Java: Passing Array to Oracle Stored Procedure
This tutorial guides us on how to pass Array objects from Java to stored procedures in Oracle and also, how to retrieve an array object in Java. All PLSQL arrays can not be called...
How To Convert Number into Words using Oracle SQL Query
How can you convert a number into words using Oracle Sql Query? What I mean by Number to Word is: Here’s a classy query which will convert number into words.Please see the query below:...
Fast data copy with “Create Table Select From” in PL/SQL
Although I work mainly in Java/J2EE, recently I had a requirement in Oracle to take temporary backup of a table and compare the data of original table with this backup table. So I had...