Re: any ideas on why this pice of code dosnt work??

On 8 Aug 2006 09:47:39 -0700, "Vinay Bhushan" <bhushanvinay_at_gmail.com> wrote:

>DECLARE
> v_userTabColumns INT;
>BEGIN
>
> SELECT COUNT(*) INTO v_userTabColumns
> FROM USER_TAB_COLUMNS
> WHERE TABLE_NAME ='T'
> AND COLUMN_NAME ='ABCD';
>
> IF v_userTabColumns >0 THEN
> DBMS_OUTPUT.PUT_LINE ('<<ABCD>><<T>> already Exists');
> ELSE
> ALTER TABLE T ADD (ABCD VARCHAR2(50));
> DBMS_OUTPUT.PUT_LINE ('New column <<ABCD>> for <<t>>
>created.');
> END IF;
>
>END;
I responded to this in comp.databases.oracle.misc

PLEASE do not cross- and/or multipost as most people responding here monitor all groups.

--
Sybrand Bakker, Senior Oracle DBA