Search results for query: *

Don't know much about the way the users are accessing the oracle db but you could output the reports in html and then access using a browser from windows clients. You would of course then need to be running a web server of some sort but it's not as bad as every user needing to ftp to the...

Sure...;-) Shipto Customer: 111111111 lineitem 1244444444 number sold 444444 address city zip Shipto Customer: 99987000 lineitem 09999 number sold 999 address city zip Shipto Customer: 111111111 lineitem 678884 number sold 444444 address city zip

Wondering if anyone has had to process between 2 different expressions using either awk or sed. I'm looking at finding a line with a specific customer number, then capturing the lines following until it hits the next line containing "customer number" which may or may not be the same...

My question is : When using the set transaction use rollback segment in a plsql procedure, I am receiving an error saying the statement must be the first. I have the following procedure to analyze tables based upon a small window of time and want to use the larger rollback segment but when I...

Thanks...Actually, I granted analyze any to the user executing the procedure and that cured it. Even tho the user had DBA privileges the grant was necessary. Thanks for your reply.

Anyone have any experience using execute immediate? I'm trying to use a procedure to rebuild indexes. Problem is the indexes are SAP flavor with the ~ symbol in them which is giving oracle fits. I've been able to hide the symbol in a normal sqlplus prompt with " ( double quotes ) around...