Create procedure<procedure name>(<PARAMS>)As. BEGIN<SQL Queries>END;
Replace procedure<procedure name>(<PARAMS>)As. BEGIN<SQL Queries>END;
DROP procedure<procedure name>
SHOW Procedure<procedure name>
Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training
Call procedure<procedure name>(<PARAMS>)
Create procedure (Dcone1 INTEGER,DName1 varchar(30))
BEGIN
DECLARE DEPTNAME VARCHAR(30);
SET DEPTNAME=DNAME1;
INSERT INTO DEPT(DCODE, DNAME)Values(:Dcode1,:DEPT NAME);
END;
Call p – sample(70,‘IT’);
Select* From Dept;
Create procedure SP(PID INTEGER, out op INTEGER)
BEGIN
DECLARE VAR1 INTEGER;
SELECT Party income into:var1 from party where party =pid;
Select op=var1*10;
END;
Call SP(1, OP)
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/4
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox