There are 3 types of the parameter being specified.
IN – used for input type parameter only.
OUT – used for output type parameter only.
INOUT – INOUT can be both input and output type parameter.
By default, if the parameter type is not specified, the parameter is assumed to be of the “IN” type.
BEGIN – This keyword introduces a compound statement. A compound statement can contain all the SQL statements and variable declarations for the stored procedure. This compound statement has to be terminated with the END keyword.
END – This is the terminating keyword for a BEGIN-END compound statement.
DECLARE – DECLARE keyword can be used for a local variable declaration or a cursor declaration or a condition (error/exception) handler declaration.
ITERATE – If you want to terminate the execution of the current iteration of a labeled iteration statement, and start the next iteration, use this keyword ITERATE. If you are using WHILE or FOR loops then the next iteration would start conditionally and in case if you are LOOP and REPEAT the next iteration would start unconditionally.
LEAVE – Used to exit out from a current iteration and continue execution outside the current iteration.
DEFAULT – This is an optional keyword for introducing a default value for the local variables.
SET – SET is the keyword that is used for assigning a value to a variable or parameter.
CALL – Used to invoke the procedure.
PRINT – This command is used to display something to the screen. Mostly used for testing/debugging purpose. Remember to enable this option while creating the procedure.
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links
4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.