Grant on tables using wildcards
Sometimes you have to make a lot of grants for a specific user. It could be...
All posts by xavsio4
Get table space details from schema in Oracle
select df.tablespace_name "Tablespace", totalusedspace "Used MB", (df.totalspace - tu.totalusedspace) "Free MB", df.totalspace "Total MB", round(100 *...
A regexp example in Oracle
Lately I had to extract a variable series of numbers within a string. The string was...
Create a synonym in Oracle
Simplify the way you use Oracle objects by creating synonyms. For example, to avoid prefixing with...
Simple Table duplicate with Oracle
Well, the title tells it all. --this will copy only the structure. notice the impossible...
Free stock photos
Sometimes in web development you need photos to use as illustrations. I’m a huge fan of...
Illustrator : Export layers to SVG
Lately I’ve been thinking about an animation using SVG files out of an Illustrator design I...
WordPress Direct FTP
Paste the following line in your wp-config.php file. This file is located in the root of...
Update a partion key making it change of partion
One day i needed to update the key of a partitioned table (usually a date). But...