ç¨declare声æçåéä½ç¨å¨blockä¸ã
variableæ¯sqlplusä¸å®ä¹åéçå½ä»¤ãä»å®ä¹çåéå¨ä¸ä¸ªsqlplusè¿æ¥ä¸ææã
SQL> show user
USER 为"YANGTK"
SQL> var
SP2-0568: æªè¯´æç»ååéã
SQL> var test number
SQL> var
åé test
æ°æ®ç±»å NUMBER
SQL> conn / as sysdba
å·²è¿æ¥ã
SQL> show user
USER 为"SYS"
SQL> var
åé test
æ°æ®ç±»å NUMBER
SQL>
--------------------------------------------------------------
variableç¸å½äºä¸ä¸ªsql*plusç¯å¢çå
¨å±åé,declareéå®ä¹çæ¯pl/sqlä¸çå±é¨åéã
温馨提示:答案为网友推荐,仅供参考