title: Difference between DECLARE, VARIABLE and DEFINE in PL/SQL
body: <p>i am new to PL/SQL. I am confused with the difference between following. </p>
  
  <p><strong>DECLARE</strong>
  name Varchar2(20);</p>
  
  <p><strong>VARIABLE</strong>
  name Varchar2(20);</p>
  
  <p><strong>DEFINE</strong> name = 'myname';</p>
  
  <p>Thanks in advance. </p>