Re: SQL possible equivalent
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Wed, 30 May 2007 17:51:04 -0700
euan.garden@xxxxxxxxx wrote:
On May 30, 8:10 am, DA Morgan <damor...@xxxxxxxxx> wrote:Jeff Kish wrote:I have a script for mssql serverthat checks to see if a table exists... ifThe issue isn't how ... the issue is why. Oracle is NOT a Microsoft
it does it drops it and recreates it.
I'm wondering how to do this using only sql if possible. I can figure it out
using pl/sql but I'm not sure of the correct approach (or even if it is
possible) using just sql.
I realize you can select from user_tab_cols like this:
select table_name from user_tab_columns where upper(table_name) = 'ASSET'
but how do I fit this into a sort of ifdef else sort of flow control in sql?
Can someone point me in the right direction? Do I need to somehow insert
pl/sql into the sql?
thanks
Jeff Kish
product rebranded. The concepts are different, the architecture is
different, and kludges such as the one you are asking about used inSQL Serveronly because of its Ingres origins are possible but never
done by people who learn the product.
So the answer is you can do it using Native Dynamic SQL but you should
instead learn Oracle unless you wish to write really really bad code.
--
Daniel A. Morgan
University of Washington
damor...@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
- Show quoted text -
Ingres? Thats a new one, I suggest a little fact checking;
http://blogs.msdn.com/euanga/archive/2006/01/19/514479.aspx
I agree as I am correct.
Allow me to quote from:
http://www.referenceforbusiness.com/history2/49/Sybase-Inc.html
Sybase was founded in 1984 by Mark Hoffman and Robert Epstein. Hoffman had previously worked as an executive at a company called Britton Lee, which pioneered the field of database computing. He joined Epstein, who had helped to create an early relational program called Ingres while working toward his Ph.D. at the University of California at Berkeley. Together, the two set out to market a cutting-edge relational database management system (RDBMS), which would organize information and make it available to many computers in a network.
The origin of Sybase, with respect to concepts and architecture, is
Ingres and thus it too is the underlying foundation of SQL Server.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- Follow-Ups:
- Re: SQL possible equivalent
- From: Jim Smith
- Re: SQL possible equivalent
- References:
- SQL possible equivalent
- From: Jeff Kish
- Re: SQL possible equivalent
- From: DA Morgan
- Re: SQL possible equivalent
- From: euan . garden
- SQL possible equivalent
- Prev by Date: Re: SQL possible equivalent
- Next by Date: Re: How to call SQLPlus ? Diff between iSQL*Plus ans SQL*Plus ?
- Previous by thread: Re: SQL possible equivalent
- Next by thread: Re: SQL possible equivalent
- Index(es):
Relevant Pages
|
|
