PL/SQL 더미데이터 넣기, 정렬 (프로시저)

PL/SQL 종류
Package
user function
stored procedure
trigger
anonymous block

--PL/SQL : Procedual Language(절차적인언어)/Structed Query Language)
--절차적인 : 분기 , 반복, 변수
--DECLARE, EXCEPTION : 선택
--BEGIN, END : 필수
/
DECLARE 

BEGIN
    --I : 자동선언정수형변수
    FOR I IN 1..30 LOOP
    INSERT INTO BOOK(BOOK_ID, TITLE, CATEGORY, PRICE, INSERT_DATE, CONTENT)
    VALUES(
        (SELECT NVL(MAX(BOOK_ID),0)+1 FROM BOOK),
        '제목'||I,'카테고리'||I,10000,SYSDATE,'내용'||I
    );
    END LOOP;
    COMMIT;
    EXCEPTION 
        WHEN OTHERS THEN
          DBMS_OUTPUT.PUT_LINE('오류 발생 : '||SQLERRM);
END;
/

WITH T AS(
    SELECT ROW_NUMBER() OVER(ORDER BY BOOK_ID DESC) RNUM
    , BOOK_ID, TITLE, CATEGORY, PRICE, INSERT_DATE, CONTENT
    FROM   BOOK
)
SELECT T.RNUM, T.BOOK_ID, T.TITLE, T.CATEGORY, T.PRICE
     , T.INSERT_DATE, T.CONTENT 
FROM   T