Sometimes the simplest tricks just ease your life the nice way.
While typing code in TOAD, I just found out those two handy keyboard shortcuts
<CTRL> + . = Autocompletes tablenames
<CTRL> + T = Popups the list of column names
I want to select everything from emp and dept joined on deptno.
SELECT*FROM E<CTRL+.> e,D<CTRL+.> d
where e.<CTRL+T><down><enter>=d.<CTRL+T><enter><CTRL+ENTER>
Especially [...]
When it comes to setting the optimizer_mode parameter you often hear people say that first_rows_N (for one of the legal values of N) should be used for OLTP systems and all_rows should be used for decision support and data warehouse systems.
There is an element of truth in the statement - but it’s really a hangover from [...]
I’ll be in Edinburgh on 20th and 21st November presenting two of my one-day events: “Trouble-shooting and Tuning”, and “Writing Optimal SQL”.
The event is being organised by PiSec Ltd, the company name for Thomas Presslie - long time organiser and supporter of the UKOUG in Scotland).
For registration or further details email education@pisec.org or zoe.presslie@pisec.org.
Discounts are available [...]
Mix is one year old today.
Seems like it’s been around forever, at least to me, but you’ll recall we launched it to very little fanfare at the beginning of OpenWorld 2007.
Mix didn’t really get much promotion at all until Marketing decided to solicit session ideas from the community for OpenWorld 2008 back in May. Over [...]
This is a temporary post that was not deleted. Please delete this manually. (f8f9dc5a-3278-45d5-abcf-9eac5a908299 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
I did a bit more sightseeing around Auckland recently. Here are some pictures of the Sky Tower and The Domain.
I leave New Zealand in a few hours so I’ll be offline for about 2 days while I’m in transit.
Cheers
Tim…
I found this nugget in Paul’s Google Reader Shared Items feed: “Get Satisfaction Launches Socialized Ad Policy“.
As previously documented here, we like what Get Satisfaction does, and even though ads usually put me right into a coma, my curiosity about how ads could be “smart” (from Paul’s note in Reader) overcame me.
Turns out it is [...]
You know that feeling when you’re working hard on a system, did a lot of changes, finally get the required result and start clean up old code?I was in that stage… but then it went wrong: I deleted the wrong components and even some pages…So what do…