Sparkdream

--- --- ======================PL-SQL Basic==================== --- /**create table stu*/ create table stu( id number(3), name char(8), score number(3), age number(2), sex char(2) )...

config.sql -- Clean up the database objects DROP TRIGGER validateUser; DROP PROCEDURE check_email; DROP TABLE userinfo; -- Create the table CREATE TABLE userinfo( username VARCHAR2(20...

search.sql /** SET SERVEROUTPUT ON PROMPT PROMPT | ------------------------------------------------------------------------ | ; PROMPT | Enter your choice for the search ...

update.sql UPDATE userinfo SET phone='650.221.2019',email='@johnemails.com', password='john' WHERE username='John ';