Loading ...
Sorry, an error occurred while loading the content.

Re: [SQLQueriesNoCode] Stored Procedure Help

Expand Messages
  • Chirag Mewada
    @ sign represents parameter and you are creating varialble so first of all remove @ sing bofore the name of variable and if you are using paramenter then find
    Message 1 of 10 , Jun 22, 2011
    • 0 Attachment
      @ sign represents parameter and you are creating varialble
      so first of all remove @ sing bofore the name of variable
      and if you are using paramenter then find from google or w3cschool
      that how to use parameteres in stored procedures


      On 5/23/10, arun aarun <saarun_emf@...> wrote:
      >
      > SQL is a Database Language SQLPlus is an Oracle Tool to Acess the SQL.
      > --- On Sat, 22/5/10, Rashmi Soni <rashmi.soni42@...> wrote:
      >
      > From: Rashmi Soni <rashmi.soni42@...>
      > Subject: Re: [SQLQueriesNoCode] Stored Procedure Help
      > To: SQLQueriesNoCode@yahoogroups.com
      > Date: Saturday, 22 May, 2010, 5:01 AM
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      > what is difference between sql and sqliplus?????????
      >
      >
      >
      > ________________________________
      >
      > From: Rob Richardson <Rob.Richardson@...>
      >
      > To: SQLQueriesNoCode@yahoogroups.com
      >
      > Sent: Fri, 7 May, 2010 10:31:57 PM
      >
      > Subject: RE: [SQLQueriesNoCode] Stored Procedure Help
      >
      >
      >
      > Setting aside the mystery of what you are trying to accomplish, why do
      >
      > you expect to use a value before the select statement that puts the data
      >
      > into the value? Put your select statement on top of the if statement.
      >
      >
      >
      > RobR
      >
      >
      >
      > [Non-text portions of this message have been removed]
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      >
      > [Non-text portions of this message have been removed]
      >
      >


      --
      Chirag A Mewada
      =======================================
      (Assistant Professor)
      NaranLala College of Professional & Applied Sciences
      Navsari.
      =======================================

      ".....IF IT WAS EASY, EVERYBODY WOULD BE DOING IT....."
    Your message has been successfully submitted and would be delivered to recipients shortly.