this my SQLI want

Create a PARAMETER based SELECT QUERY stored procedure which return records based on parameters?

Create an UPDATE query based stored procedure

CREATE TABLE Subscription ( Subscription_ID INT NOT NULL PRIMARY KEY, SubscriptionType CHAR(1) NOT NULL CHECK (SubscriptionType IN ('B', 'A', 'U')), Start_date date not null, End_date date not null, Screen_Number number(1) not null, UNIQUE (Subscription_ID,SubscriptionType) ); CREATE TABLE Basic_S ( Subscription_ID INT NOT NULL PRIMARY KEY, SubscriptionType CHAR(1) DEFAULT 'B' NOT NULL, CHECK (SubscriptionType ='B'), Free Trial varchar2(20), FOREIGN KEY (Subscription_ID,SubscriptionType) REFERENCES Subscription (Subscription_ID, SubscriptionType) );

CREATE TABLE Advanced_s ( Subscription_ID INT NOT NULL PRIMARY KEY, SubscriptionType CHAR(1) DEFAULT 'U' NOT NULL, CHECK (SubscriptionType ='A'), KidsContent_SD varchar2(20), FOREIGN KEY (Subscription_ID, SubscriptionType) REFERENCES Subscription (Subscription_ID,SubscriptionType) ); CREATE TABLE Unlimited_S ( Subscription_ID INT NOT NULL PRIMARY KEY, SubscriptionType CHAR(1) DEFAULT 'U' NOT NULL, CHECK (SubscriptionType ='U'), KidsContent_4K varchar2(20), SportContent varchar2(20), Download varchar2(20), FOREIGN KEY (Subscription_ID, SubscriptionType) REFERENCES Subscription (Subscription_ID,SubscriptionType) );

create table User_A ( User_ID number (10) primary key, User_name varchar2(12), Email varchar2(13), phone number (10), Address varchar2(14), Subscription_ID number(5), FOREIGN KEY (Subscription_ID) REFERENCES Subscription(Subscription_ID) );

create table Payment ( Payment_ID number (5) primary key, Payment_date date, Due_date date, Amount_paid number (6), Method varchar2(7), CcExp_Date date, CcName varchar2(9) not null, CcNumber number (10) not null, CcCVSN number (3) not null, User_ID number (10), FOREIGN KEY (User_ID) REFERENCES User_A(User_ID) );

create table video ( Video_ID number (4), Release_Date Date, Title varchar2 (20), Rate varchar2 (4), Duration_v varchar2(20), primary key (Video_ID) ):

create table Quality ( Video_Quality varchar2(8), Video_ID number (8), Subscription_ID INT, FOREIGN KEY (Video_ID) REFERENCES Video(Video_ID), FOREIGN KEY (Subscription_ID) REFERENCES Subscription (Subscription_ID) );

Create table Category_C ( vid_category varchar (20), Video_ID number (B), Primary key (vid_category), FOREIGN KEY (Video_ID) REFERENCES Video (Video_ID) );