This may work for you: set define off Otherwise the ampersand needs to be at the end of a string, ‘StackOverflow &’ || ‘ you’ EDIT: I was click-happy when saving… This was referenced from a blog.
According Oracle these locations are searched for tnsnames.ora, resp. sqlnet.ora and ldap.ora: Oracle Net files in present working directory (PWD/CWD) TNS_ADMIN defined sessionally or by user-defined script TNS_ADMIN defined as a global environment variable TNS_ADMIN defined in the registry Oracle Net files in %ORACLE_HOME/network|net80\admin (Oracle default location) However, I am not sure whether each application/driver … Read more
You could also use the following, although it does introduce spaces between fields. set colsep , — separate columns with a comma set pagesize 0 — No header rows set trimspool on — remove trailing blanks set headsep off — this may or may not be useful…depends on your headings. set linesize X — X … Read more
I know this is an old thread, but I just stumbled upon it and I feel this has not been explained completely. There is a huge difference in SQL*Plus between the meaning of a / and a ; because they work differently. The ; ends a SQL statement, whereas the / executes whatever is in … Read more