can someone assist what am I doing wrong!..
I have two tables shop and shop_owner I want to have a procedure which will be adding shops to the mall(if owner open a new shop)
CREATE PROCEDURE update_mall
AS
BEGIN
declare @man varchar(30);
select * from shop_owner where owner_Id = 'MAN001' //assuming MAN001 is the ID admin enter in search box
set @man = 'MAN001'
if(@man= 'MAN001')
begin
insert into shop (owner_Id,shop_name,shop_location) values
('MAN001','Shine and smile','Kariakoo');
end
END
Procedural language is the concluding part of sql oracle and it is very beneficial when storing a value into the database, moreover its secured and safe to keep it safe.