Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jmannix

    chunk fails sanity check, instance won't come online

    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...
  2. jmannix

    Oracle heterogeneous services using generic connectivity

    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...
  3. jmannix

    formatting output from SELECT *

    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...
  4. jmannix

    formatting output from SELECT *

    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...
  5. jmannix

    changing a fieldname

    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.
  6. jmannix

    using dbms_output

    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...
  7. jmannix

    Optimizing Oracle queries

    Does anyone know if the order by which you place clauses in the WHERE section of a query can improve the performance of a SQL statement? Thanks, Joe
  8. jmannix

    using dbms_output

    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...
  9. jmannix

    using dbms_output

    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
  10. jmannix

    using dbms_output

    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...

Part and Inventory Search

Back
Top