Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which is faster? <> or Between
On 30 Jun 2003, pablo_at_dev-null.com wrote:
> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in
> news:3F006029.ECE34F77_at_exxesolutions.com:
>
>> Now if you don't have CREATE TABLE that could be a problem. But if >> you don't have CREATE TABLE you aren't a developer.
Does anybody alter the create table statement for the plan_table to be
create global temporary table PLAN_TABLE (
then create a public synonym to that? Each developer could then run a non-named plan, then their plan query and then truncate the plan_table, all without having to have created a table or mess up someone else by cleaning it out with a truncate.
(Oh well, this is how I do it for development instances, so that nobody has to continue to recreate their plan_table as their schema gets cleaned out)
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Sun Jul 13 2003 - 23:14:12 CDT