| 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
![]() |
![]() |