Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    41

    Unanswered: How to return customized format in PL/SQL?

    I'm writing a stored function called MAKE_EMAIL that will accept input arguments for first name and lastname and will return a varchar2 value containing the email address in the form of first initial of the firstname followed by the full last name followed by @hpu.edu.

    Ex: Calling select make_email('Edward','Souza')from dual would return the single value: 'esouza@hpu.edu'

    Here is what I have come up with:

    Code:
    create or replace function MAKE_EMAIL(lastname varchar2(10),firstname varchar(10))
    return VARCHAR IS
    
    f_name VARCHAR;
    l_name VARCHAR;
    
    BEGIN
    
    
    RETURN 
    END MAKE_EMAIL;
    /
    Could anyone please help me how to achieve the goal? I'm new in PL/SQL.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    There are some books you should read before you start coding. Have a look at the Most popular section.

    Your first reading should be the "Concepts" book. Then combine knowledge gathered in "PL/SQL User's Guide and Reference", "Application Developer's Guide - Fundamentals" and "SQL Reference"

    Because, you came up with nothing. The fact that you are new to PL/SQL makes no difference. Spoonfeeding is counter-productive.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •