Post by Jeff Gril » Sat, 04 May 2002 23:58:51

I'm looking for a routine to parse an address for POSTNET barcoding.  Any
help would be appreciated.

Thank, Jeff


1. What is parse -vs- hard parse?

I'm working with a system running Ora Ent. Ed.
bstat/estat reports:
108,572 total parses and
  3,572 hard parses
for 224632 executions of SQL statements

I'm clear on what hard parses are, but what are the others?
Or rather what is going on during a non hard parse?

And is there something to infer from the ratio of these "soft" parses
to executes(96.6%)?  FYI, the application is not using bind vars, yet.
I read somewhere that Oracle reparses every sql statement that has
literals in the where clause.  If that's true, I wonder if they
meant "soft" vs hard parse?

Thanks in advance,

Sent via

2. Which directory is execute() run out of?

3. Printing postnet barcodes with paradox 8

4. Boston..Sybase/NT Engineer

5. Postnet Bar Codes?

6. Philadelphia JOB

7. Seeking TrueType POSTNET barcode font

8. dbRefreshCache in ODBC SDK calls

9. POSTNET bar codes

10. Postnet Bar Code Fonts

11. Postnet codes on reports?

12. Postnet barcodes in FM5

13. Generating PostNet barcodes