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!

  • Congratulations SkipVought 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. jimmyn1

    ODBC - stored procedure returning control chars

    hi, what are the control characters that you're getting? control M?
  2. jimmyn1

    how to get length of long column?

    here's a formula to calculate average length from metalink Note:10640.1 Table size increases proportionally with the number of rows in the table assuming average row length remains constant. While the DBA Guide provides a formula for calculating table size, it may not be as accurate as the...
  3. jimmyn1

    Web Server Load Balancer for HPUX

    hi, wouldn't you want your test instance to mirror your PROD instance? one suggestion I have is to configure your HP SA7200 to direct traffic on a certain port that you choose for test to load balance between the test servers. for example, we are running Cisco Local Directors and have...
  4. jimmyn1

    Writing to Log File From Oracle Report Concurrent Request in 11i

    Here's what metalink says: Fnd_File package need to be used only in a stored procedure/Package. If you are using anonymous block(declare..begin..end) use dbms_output.put_line package
  5. jimmyn1

    Difference between the following two querries

    I think it may have something to do with this part of the query. and exists (select b.pernr from ads_transfer_assign b where a.pernr = b.pernr... and not exists (select c.pernr from ads_transfer_assign c where a.pernr = c.pernr... since they are hitting the same tables they are cancelling...
  6. jimmyn1

    Backing up Oracle Parallel Server

    it depends. what type of backup do you want to do? do you have mirrored disks? Having OPS implies that you are using some sort of disk array (unless you're on linux and can implement OPS on a single node). If your tape backup device is on one of the servers, that server will handle all the...

Part and Inventory Search

Back
Top