difference if statement in oracle vs SQL server

  • I would like to know the difference of usage and syntax of if statement between T-SQL vs PL-SQL.

    I noticed the T-SQL often uses Begin end after If statement, but Pl-SQL does not .

    Thanks

  • sqlfriend wrote:

    I would like to know the difference of usage and syntax of if statement between T-SQL vs PL-SQL.

    I noticed the T-SQL often uses Begin end after If statement, but Pl-SQL does not .

    Thanks

    So look it up in the documentation of both RDBMSs. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply