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

    DBMS_OUTPUT.PUT_LINE

    I have a PL/SQL script that is using DBMS_OUTPUT.PUT_LINE to create a file that has fixed lenth lines. Some of the fields need to be all spaces (example: every line should start with 12 spaces). The put_line strips the leading spaces - how do I stop this?
  2. staceyz

    can/how do I use a stored procedure on each record

    Thanks MikeJones! I added a stored function, and accomplished the change I needed to and the report runs in the same amount of time [with a new index that was added too!] Thanks for the help!
  3. staceyz

    can/how do I use a stored procedure on each record

    Is it possible to call a stored procedure for every record? I have an existing report that has a query with the order number and weight. I need to add criteria, and sometimes return 0 for the weight, based on if the order has already closed in another accounting period. I need to determine this...
  4. staceyz

    slow report with view, will a SP speed it up?

    Hello, I have a pretty intensive query for a certain report that is run about once a week. So far, I've built a view and then I have 3 queries in my report [Oracle Reports version 2.5]. The Oracle database is version 7.3.4. The view takes about 3 minutes to run, so the report then takes about 1...

Part and Inventory Search

Back
Top