title: Creating a user defined function in oracle SQL called lastnamefirst
body: <p>I am using oracle SQL developper.</p>
  
  <p>I am trying to create a function that will accept two parameters (first and last name) and return them as one variable, with the last name showing up first. Here is my function.</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION LASTNAMEFIRST
  (
  varFirstName IN VARCHAR2,
  varLastName IN VARCHAR2
  )
  RETURN VARCHAR2 AS 
  BEGIN
  
  DECLARE varFullName VARCHAR2;
  
  DEFINE varFullName := CONCAT(varLastName,' ' ,varFirstName);
  
    RETURN varFullName;
  END LASTNAMEFIRST; 
  </code></pre>
  
  <p>I am receiving an error on the semicolon at 'end lastnamefirst' "syntax error"
  I keep trying to change small things and that same error just shows up in different places whenever I change things.  What am I doing wrong?</p>