Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> why cant i do this?? any clues on how i should go about
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; Received on Tue Aug 08 2006 - 11:42:30 CDT
![]() |
![]() |