.

Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Tuesday, 4 November 2014

Executing procedure in Teradata

We can execute procedure in Teradata as shown below:-

CALL PROCEDURE PROCEDURE_NAME;

If you have procedure called PROC_UPSERT then:-

CALL PROCEDURE PROC_UPSERT;

If your procedure is parameterize then:-

CALL PROCEDURE PROCEDURE_NAME(PARAMETER (S)) ;

Chanchal Wankhade

Greetings everyone, I go by the name Chanchal Wankhade, and I've been actively engaged in various back-end technologies for over 15 years, specializing in SQL, Oracle, Teradata, MySQL, as well as reporting tools such as Business Objects (BO) and the ETL tool BusinessObjects Data Services (BODS). In my journey, I've authored informative books on SQL, Oracle, and Teradata, including titles like "PL/SQL FOR ALL," "PL/SQL ONE STOP REFERENCE," "TERADATA BASIC UTILITIES," and "START-UP GUIDE FOR ORACLE DAB'S." Additionally, I've ventured into the realm of Mutual Funds and authored a book titled "Mutual Funds For All." These books, namely "PL/SQL FOR ALL," "PL/SQL ONE STOP REFERENCE," "TERADATA BASIC UTILITIES," "START-UP GUIDE FOR ORACLE DAB'S," and "Mutual Funds For All," are available for free download on Google Books. What sets these books apart is the incorporation of real-life examples, followed by syntax explanations and actual use cases. Feel free to explore and benefit from these valuable resources. Best regards, Chanchal Wankhade

Please provide your feedback in the comments section above. Please don't forget to follow.