Explain Stored Procedure in detail.. its structure…exact syntax .. in and out?

devquora
devquora

Posted On: Jun 15, 2021

 

Stored procedures differ from ordinary SQL statements and from batches of SQL statements in that they are precompiled. A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Teradata Interview Questions

    Explain Teradata utilities. What is MultiLoad , Fast Load, Tpump ?

    Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time. FastLoad can sort the incoming rows directly into the target table. MultiLoad first...

    Teradata Interview Questions

    When do you use each of these? Why? Explain in detail.

    It is used because Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time....

    Teradata Interview Questions

    Explain Teradata Architecture in detail .

    Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET, and Access Module Processors (AMPs)....