21 March 2023
create or replace package cr_in_u is
procedure n_a(p_in varchar2);
procedure c_i(p_n varchar2, p_i number);
procedure c_i_u(p_s varchar2, p_w number);
end cr_in_u;
/
create or replace package body cr_in_u is
procedure n_a(p_in in out varchar2) as
v_cnt pls_integer;
begin
-- Check if the table already exists
select count(*) into v_cnt from user_tables where table_name = 'NUM1';
-- Create the table dynamically only if it does not exist
if v_cnt = 0 then
p_in := 'create table num1(
name varchar2(30),
id number)';
execute immediate p_in;
commit;
end if;
end;
procedure c_i(p_n varchar2, p_i number) as
begin
insert into num1 values (p_n, p_i);
end;
procedure c_i_u(p_s varchar2, p_w number) as
begin
update num1 set name = p_s where id = p_w;
end;
end;
/
Automation Lifecreate or replace package cr_in_u is
procedure n_a(p_in varchar2);
procedure c_i(p_n varchar2, p_i number);
procedure c_i_u(p_s varchar2, p_w number);
end cr_in_u;
/
create or replace package body cr_in_u is
procedure n_a(p_in in out varchar2) as
v_cnt pls_integer;
begin
-- Check
46538 you can try this
Automation Lifecreate or replace package cr_in_u is
procedure n_a(p_in varchar2);
procedure c_i(p_n varchar2, p_i number);
procedure c_i_u(p_s varchar2, p_w number);
end cr_in_u;
/
create or replace package body cr_in_u is
procedure n_a(p_in in out varchar2) as
v_cnt pls_integer;
begin
-- Check
👆 have you tried?
46538Tryed same issu
If you could provide me with the specific error message and your code, I can try in my system..
create or replace package cr_in_u is
procedure n_a (p_in varchar2);
procedure c_i (p_n varchar2,p_i number);
procedure c_i_u (p_s varchar2,p_w number);
end cr_in_u;
create or replace package body cr_in_u is
procedure n_a
(p_in in out varchar2) as
begin
p_in := 'create table num1(
name varchar2(30),
id number)';
EXECUTE IMMEDIATE p_in;
commit;
end;
procedure c_i (p_n varchar2
,p_i number) as
begin
insert into num1 values(p_n,p_i);
end;
procedure c_i_u (p_s varchar2,p_w number) as
begin
update num1 set name = p_s where id = p_w;
end;
end;
/
46538create or replace package cr_in_u is
procedure n_a (p_in varchar2);
procedure c_i (p_n varchar2,p_i number);
procedure c_i_u (p_s varchar2,p_w number);
end cr_in_u;
create or replace package body cr_in_u is
procedure n_a
(p_in in out varchar2) as
begin
p_in := 'create table num1
create or replace package body cr_in_u is
procedure n_a (p_in in out varchar2) as
begin
p_in := 'create table num1(
name varchar2(30),
id number)';
EXECUTE IMMEDIATE p_in;
commit;
end;
procedure c_i (p_n varchar2, p_i number) as
begin
insert into num1 values (p_n, p_i);
end;
procedure c_i_u (p_s varchar2, p_w number) as
begin
update num1 set name = p_s where id = p_w;
end;
end cr_in_u;
46538create or replace package cr_in_u is
procedure n_a (p_in varchar2);
procedure c_i (p_n varchar2,p_i number);
procedure c_i_u (p_s varchar2,p_w number);
end cr_in_u;
create or replace package body cr_in_u is
procedure n_a
(p_in in out varchar2) as
begin
p_in := 'create table num1
Did your issues resolved?
23 March 2023
For anyone looking to make an entry-level/Mid Level transition into the analytics domain, this post may be helpful in offering some guidance with your preparation
👉 My name is Vishal Kumar working as a data analyst and as a trainer of SQL, excel and tableau from past 3 years.
👉 I will be providing detailed training in SQL, Excel and tableau from basics to advance level in 2 months and help you get a job in data analytics domain.
👉 Along with the course, I will also be helping you with placement assistance in the form of 2 real-time projects, Resume building, mock interview sessions, Interview preparation and I will also provide you with 5000+ email ids of HRs and Talent acquisition teams of Various companies so that you can use them to send bulk mails for application which will get you lot of interview calls and job opportunities every day.
👉 The cost of the entire course is INR 36000 which you can pay in three installments but for students who are enrolling today, I am giving you a discount of Rs 6000, So the cost of the entire course lowers to Rs 25,000.
👉 For enrolling into the course, Kindly contact me directly through phone/whatsapp.- +91-9798936844
👉 The classes will be held on zoom meetings.
Both Morning timings and evening timings are available.
Thanks
Vishal kumar
Contact number - +91-9798936844
26 March 2023
27 March 2023