Query user defined types over database link

Querying tables over database link is very common today. But what happens when we have a table that depends on one or more user defined types? Oracle needs to know the structure of our table and it’s columns when it receives it over the DB link. However, it cannot retrieve that information from remote server … Read more Query user defined types over database link

Get yesterday’s date into a variable on AIX

As many of you know default date command on AIX doesn’t support “–date” parameter as Linux systems do. So, what can you do if you want to display another date in your shell script? There are some scripts roaming around the web, but the simplest thing i found is this. Get your time zone (let’s … Read more Get yesterday’s date into a variable on AIX