Live ORACLE

if you are Oracle Developer ,than this Blog most likely will make you happy.

About my Blog

This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.

About Me

I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.

Assigning Values to Variables With the Assignment Operator

DECLARE

  wages          NUMBER;

   hours_worked   NUMBER := 40;

   hourly_salary  NUMBER := 22.50;

   bonus          NUMBER := 150;

   country        VARCHAR2(128);

   counter        NUMBER := 0;

   done           BOOLEAN;

   valid_id       BOOLEAN;

   emp_rec1       employees%ROWTYPE;

   emp_rec2       employees%ROWTYPE;

   TYPE commissions IS TABLE OF NUMBER INDEX BY PLS_INTEGER ;

   comm_tab       COMMISSIONS;

BEGIN

  wages := (hours_worked * hourly_salary) + bonus;

  

  country := 'France';

  

  country := Upper('Canada');

  

  done := (counter > 100);

  

  valid_id := true;

  

  emp_rec1.first_name := 'Antonio';

  

  emp_rec1.last_name := 'Ortiz';

  

  emp_rec1 := emp_rec2;

  

  Comm_tab(5) := 20000 * 0.15;

END;

/

Share/Save/Bookmark

0 comments:

Post a Comment



Newer Posts Older Posts Home Page
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-