By Robert Jones – Everyone has some way to inititalize variables in SQL*PLUS. My favorite is to use the “col” directive with “new_val” option. This approach does not require a spoolfile making it somewhat easier to use in SQL*PLUS coding choirs.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help