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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.