Re: How do I alter a table in WEBDB?

From: R�diger J. Schulz <johannes.schulz_at_web.de>
Date: 09 Nov 2001 11:05:02 +0200
Message-ID: <3bebaa4e$1_at_netnews.web.de>

try to use the dba-studio application. there you have the possibility to alter "all" tables in the database.
the associated ddl-sql-statement is shown under the button "show sql". and: while converting an alpha column into a number-column, oracle checks, if there are all valid numbers in the previous column!

hth
R�diger J. Schulz
rjs_at_berlin.de

jrappa_at_hammer.net (JCR) wrote:
>Hi, when I created a table using WEBDB I accidentally made a column
>alph null. How can I alter the table to fix this and make it numeric
>not null? I've looked in the doc's and under help and I see nothing
>regarding this. Did I miss it? I'd hate to re-create the table, being
>I have a form already associated with it. Any help is appreciated and
>thanks in advance.

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de

Received on Fri Nov 09 2001 - 10:05:02 CET

This message: [ Message body ]
Next message: Niall Litchfield: "Re: Can you login as SYS using OCI in 9i ?"
Previous message: Roy: "difficult query (returning into) ???"
In reply to JCR: "How do I alter a table in WEBDB?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message