Database

SELECT TO_CHAR( SYSDATE,    
                'dd.mm.yyyy hh24:mi:ss'    
              ) AS CurrentTime,
       TO_CHAR( TO_DATE('09:00','hh24:mi') -- results in first day of this month at 09:00
                + INTERVAL '19' HOUR       -- adding hours
                + INTERVAL '09' MINUTE,    -- adding minutes
                'dd.mm.yyyy hh24:mi:ss'    -- formatting
       ) AS AddedTime
FROM dual;

CURRENTTIME	ADDEDTIME
6.8.2008 21:18	2.8.2008 4:09

CREATE PROCEDURE mySchema.MyProcedure
(
    ... Parameters go here ...
)
AS
... SQL Code Goes here ...
GO

compad wrote:

how to declare variable

DECLARE @myVariable int -- or what ever type you want.

compad wrote:

how to check condition

IF @myVariable = 123
BEGIN
   ... Some SQL Code Here
END
ELSE
BEGIN
   ... Some other SQL Code here
END

compad wrote:

I am aware of Oracle Procedure. Is the same syntax or something different.

compad wrote:

If you have any link for tutorial. please forward it to me.

SELECT *<br />
FROM   sys.databases