Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Newbie question: How to check for a tables existence in a smart (fast) way ??

Newbie question: How to check for a tables existence in a smart (fast) way ??

From: Jørgen Haukland <jorgen.hauikland_at_fou.telenor.no>
Date: 1998/01/08
Message-ID: <6935n9$nrp@info.telenor.no>#1/1 







Hey !



I'm working on an application and need to create some tables if they don't
already exists - sometimes they do. I've tried to find a smart SQL statement
but i end up with something that lists smaller or larger parts of the table.
This is no good solution because this table can occasionally be quite large
(50 - 60 MB). I need a statement that don't do any searching in the table,
just sees if it's there.



Any suggestions ??



Private e-mails are welcome as long as they also are submitted to the group.



Joergen Haukland


NORWAY


e-mail: jorgen.haukland_at_fou.telenor.no
Received on Thu Jan 08 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US