DEFINE command in oracle help

rock pora

Well-known member
  • May 18, 2011
    11,951
    2,791
    113
    ###~.:::.සියනෑ කෝරළේ.::.~##
    e bn menna meke awla mokadda bn

    Code:
    set serveroutput on;
    DEFINE P_No := 100   ;
    Declare
    no Number(5); 
    BEGIN
    no := &P_No;
    dbms_output.putLine(no); 
      
    End;
    P_No kiyana variable ekata asign karala thiyena 100, display karaganna bane bn.P_No valata value ekak enter karanna kiyala enava run karaddi.
    mokadda meke awla

    nikan balala yanna epa bn,bump ekakvath dala yamankoooo :baffled:
     
    Last edited:

    rot

    Junior member
  • Feb 28, 2008
    60
    30
    18
    set serveroutput on;
    DEFINE P_No = 100 ;
    Declare
    no Number(5);
    BEGIN
    no := &P_No;
    dbms_output.put_line(no);

    End;
     
    • Like
    Reactions: rock pora