I’ve just used the following command: SET LIN[ESIZE] 200 (from http://ss64.com/ora/syntax-sqlplus-set.html). EDIT: For clarity, valid commands are SET LIN 200 or SET LINESIZE 200. This works fine, but you have to ensure your console window is wide enough. If you’re using SQL Plus direct from MS Windows Command Prompt, the console window will automatically wrap … Read more
By default, SQL Plus treats ‘&’ as a special character that begins a substitution string. This can cause problems when running scripts that happen to include ‘&’ for other reasons: SQL> insert into customers (customer_name) values (‘Marks & Spencers Ltd’); Enter value for spencers: old 1: insert into customers (customer_name) values (‘Marks & Spencers Ltd’) … Read more
Having the same issue here (even a year later). Under linux you have to do the following: Look for the file /usr/lib/ruby/1.9.1/webrick/config.rb and edit it. Replace the line :DoNotReverseLookup => nil, with :DoNotReverseLookup => true, Restart webrick and it’ll work like a charm 🙂
SELECT NAME FROM v$database; shows the database name in oracle
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.
What is “it” in the statement “it just says the procedure is completed”? By default, most tools do not configure a buffer for dbms_output to write to and do not attempt to read from that buffer after code executes. Most tools, on the other hand, have the ability to do so. In SQL*Plus, you’d need … 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
Instead of node_name=”Geometric Vectors \& Matrices” use node_name=”Geometric Vectors ” || chr(38) || ‘ Matrices’ 38 is the ascii code for ampersand, and in this form it will be interpreted as a string, nothing else. I tried it and it worked. Another way could be using LIKE and an underline instead the ‘&’ character: node_name … 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
I had this issue and the fix was to make sure in tnsnames.ora the SERVICE_NAME is a valid service name in your database. To find out valid service names, you can use the following query in oracle: select value from v$parameter where name=”service_names” Once I updated tnsnames.ora to: TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS … Read more