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