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

    printing tabs in reports from a stored procedure?

    Is there something that I can add to the first line to make the two lines equivalent? dbms_output.put(field1); column field1 A20; thanks, -lisa
  2. misapena

    printing tabs in reports from a stored procedure?

    I would like to have the values of my fields separated by tabs (or a specified number of white spaces) in a report. My code currently looks something like this: for loop dbms_output.put(field1) dbms_output.put(field2) if condition dbms_output.put(field3) else...
  3. misapena

    Stored Procedure - expand single char to string for reports

    Thank you both Dima and Dave, you were both most helpful. -Lisa
  4. misapena

    printing tabs in reports from a stored procedure?

    Hi all, I'm trying to print tabs between my dbms_output.put(field) to format the data nicely. Any clues? Thanks, Lisa
  5. misapena

    Stored Procedure - expand single char to string for reports

    Hello all, I'm very new to this and trying to write a stored procedure that will use the if/then/else control structure to check the single character field in my db and expand it to it's corresponding string for report viewing. This is my code so far... which doesn't work: CREATE OR REPLACE...

Part and Inventory Search

Back
Top