checking for existence of table in oracle - The UNIX and Linux Forums

		The UNIX and Linux Forums > Operating Systems > SUN Solaris
checking for existence of table in oracle

google unix.com

Forums

SUN Solaris The Solaris Operating System, usually known simply as Solaris, is a free Unix-based operating system introduced by Sun Microsystems .

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Checking for existence of a flat file in UNIX !	Ariean	Shell Programming and Scripting	4	04-25-2008 02:58 PM
Integrating the Oracle Designer Legacy Table API with Oracle JDeveloper 11g ADF Busin	iBot	Oracle Updates (RSS)	0	04-06-2008 05:10 AM
Track changes to Oracle table	mervinboyz	Shell Programming and Scripting	0	03-27-2008 04:48 AM
Checking the existence of a file..	igandu	Shell Programming and Scripting	7	06-13-2007 03:47 AM
checking file existence	DILEEP410	Shell Programming and Scripting	3	01-24-2007 12:43 PM


	Powered by

#1 (permalink)

10-19-2007

kjs

Registered User

Join Date: Oct 2007

Posts: 1

checking for existence of table in oracle

how do i check from solaris for existence of table in oracle..?? the requirement is, that if the table does not exist, it is created..

The logic will be something like:

if table exists then
insert into table
else
create table
insert into table
end if

Last edited by kjs; 10-19-2007 at 03:26 AM..

Bookmarks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 11:05 AM.