Basic of PLSQL

Basic Syntext of PL SQL is

Declaration Executable command Exception Blcok End

Simple Hello world Pl Sql

DECLARE message varchar(100) := "Hello wolrd !";

Begin dbms_output.put_line(message); End;

CREATE TABLE new_table as select from old_table; index new_table grant on new table add constraints on new_table etc on new_table

http://www.naturalprogrammer.com/spring-framework-rest-api-validation/ https://lmonkiewicz.com/programming/get-noticed-2017/spring-boot-rest-request-validation/