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...
SQL Tutorials, Tips & Tricks
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:...
Row Data Multiplication in Oracle
Aggregate functions return a single result row based on a group of rows. This differentiates them from Single-Row functions which act on each row. These functions are extensively used with the GROUP BY clause...
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...
Fetch Random rows from Database (MySQL, Oracle, MS SQL, PostgreSQL)
Ever thought why would one need to fetch random rows from a database table? You may want to display some random information (like articles/pages/links) to your user. I had a requirement wherein I had...