I have Informix 9.4 running on Solaris. Earlier in the week a hard drive failed. The drive has been replaced. Two of the slices on the disk were mirrored and the mirrored slices have been recovered. However I discovered one of the slices was not mirrored, and appears to be a slice holding...
We are running Oracle 8.1.7 on a UNIX machine and would like to connect to MS SQL Server 2000 on a MS box. While reviewing Oracle's documentation we can't conclusively determine if we need additional software or not. Again we want to use generic connectivity with Oracle's heterogeneous...
Dave (Mufasa),
Thank you very much! Obviously you also have found a need to modify the format of the output. I was really kind of hoping there was some SQLPlus setting that I missed. I didn't expect a complete PL/SQL script, although I was beginning to think I would have to write...
I get frustrated when I select all fields from a large table and the column headings and values wrap across many lines. I usually perform this task on a few rows to get an idea of what values are in the fields when I am unfamilar with the information stored in the table. Does anyone have a...
I'd like to be able to change the name of a field that I added to a table. I know I can't delete and add a new one back, so I am hoping there is a way to re-name. Any help is appreciated. Thanks in advance.
Thanks to all who have previously posted suggestions/solutions. I have been using the non-printing character chr(160) as posted by Mufasa above. I have since learned that if you use format wrap with the SET serveroutput on then you can start your string with spaces.
SET serveroutput on format...
SantaMufasa/Dave,
Thanks, I thought I had tried all the non-printing characters, but obviously not. Yes, I am aware of the buffer limit. I will also check out the utl_file function, I know it exists but since coming to the group I have picked up the use of dbms_output from the others...
Thanks Dima,
I am familar with the SQL*Plus reporting but we seem to keep reverting to PS/SQL because of the complexity of the work that we do.
Thanks,
Joe
I use dbms_output.put_line and dbms_output.put to spool output. However it seems that these funtions do not like beginning spaces, otherwise I can not use dbms_output.put_line(' This is a line of text to be centered"); I have been able to insert a tab char before any spaces and get...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.