SQL & PL/SQL

create table test
(
name varchar2(100)
)

insert into test values ('SUPERUSER');

COMMIT;

CREATE TABLE TEST2
(
NAME VARCHAR2(100)
);

BEGIN
INSERT INTO TEST2 (NAME)
(select case when name='SUPERUSER' THEN
                    'APPS'
     WHEN NAME ='SUPERUSER' THEN
     'SUPPORT'
     END AS "ROLE_NAME"
     FROM TEST);
    
     COMMIT;
    
    
     END ;
    
     output getting :-
     SELECT * FROM TEST2 ;
    
     NAME
     -----
     APPS
    
    
     Required output :-
    
     SELECT * FROM TEST2 ;
    
     NAME
     -----
     APPS
     SUPPORT