Results 1 to 5 of 5

Thread: pl/sql function

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    12

    pl/sql function

    i have created a function which takes two IN parameters(lets say x and y) of varchar2 type,retturn type is varchar2. this function concatenate two parametes and return the values
    which 2 are true
    1.this function can be used against any table
    2.this function can be used only if two parameters are passed in are not null values
    3. this function will generate a sstring based on two character values passed into the function
    4. this function can be used only on tables where there is a x and y colum


  2. #2
    Junior Member
    Join Date
    Feb 2007
    Answers
    17

    Re: pl/sql function

    2,3 are right answers


  3. #3
    Junior Member
    Join Date
    Aug 2006
    Answers
    1

    Re: pl/sql function

    Option 1 is correct


  4. #4
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: pl/sql function

    Options 1 and 3 are correct....

    1. yes you can use this function against any table
    2. concatenate works with null parameters. So this option is wrong
    3. obviously this statement is true
    4. No. column names need not have to match with paramter name.


  5. #5
    Junior Member
    Join Date
    Apr 2010
    Answers
    1

    Re: pl/sql function

    i agree with jamesravid. option 1 and 3 are correct.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact