Hot answers tagged oracle-11g
The problem is most likely in you not having sufficient privileges to create the index in question -- nothing to do with EXPLAIN PLAN itself. To quote the manual, "To create an index in another schema, you must have the CREATE ANY INDEX system privilege".
You should alter your tables and indexes and specify the amount of parallel that you want. How Parallel Execution Works ALTER TABLES sales PARALLEL 8; ALTER TABLE customers PARALLEL 4;
When the user types A, the code will look like: DECLARE localvar char; BEGIN localvar := A; IF localvar ='A' then dbms_output.put_line('Please proceed to Level1'); ELSIF localvar='B' or localvar='C' then dbms_output.put_line('Please proceed to Level2'); ELSIF localvar='D' then dbms_output.put_line('Please proceed to Level3'); ELSE ...
Well, it won't win any code golf awards .. O.o ... but this should work .. the trick is you trying to convert higher letters into double digits . (ie z ==> 26) if it was 1 to 1 .. TRANSLATE would work quite nicely .. however, I'm not sure to do it more elegantly .. O.o (not sure if it's better than the REPLACE option or not .. lol) I suppose with this ...
If you change file's permissions during copy operation, tar will throw "file changes as we read it".
Only top voted, non community-wiki answers of a minimum length are eligible