Hotsos Symposium 2011
FYI: The annual Hotsos Symposium will be held March 6-10, 2011. Oracle geekyness at its best! http://www.hotsos.com/sym11.html
Read MoreA Backup for My Brain!
FYI: The annual Hotsos Symposium will be held March 6-10, 2011. Oracle geekyness at its best! http://www.hotsos.com/sym11.html
Read MoreSometimes a solution comes along and you find yourself saying: “Where have you been all my life?” So it was
Read MoreFor example, you wish to generate “sales” data for a month. For each day of the month you want to record how many sales orders were generated. The sales table then has two columns: sales_date and number_of_orders.
Read MoreBy using a pipelined function, you can create views for which you can change the definition on the fly, without using DDL.
Read MoreHere is a handy little quickie to convert an any-length decimal number to a hexadecimal using the to_char function: [sourcecode]
Read MoreDuring the creation of an installation SQL*Plus script, i wanted to be able to do some conditional branching based on
Read MoreOften, in a testing environment, you need to generate some table data. Some of this data may be random, other
Read MoreMove dates so that the week days remain the same.
Read MoreUse a keyword file in conjunction with rlwrap to provide auto-completion functionality in SQL*Plus.
Read More