Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Statement is in the wrong format

user8093006Oct 13 2013 — edited Oct 13 2013

I haven't been on here for about a week because I've managed to avoid using SQL Developer.

If I enter PL/SQL statements in lowercase , then I want them to STAY in lowercase , instead of having

SQL Developer CHANGE them to a format which IT thinks appropriate.

Similarly, when I enter something in UPPERCASE, then I want it to stay in UPPERCASE .

Does this sound easy ?

I am the author of this source code and I want it in MY format, not the format some "clever" programmer at Oracle

decided upon. 

So how do I negate/inhibit/switch off this 'gimmickware" in SQL Developer ?


Comments

Brian Bontrager
If you want to load several tables at once in parallel, keep them as separate control files. sqlldr loads one thing at a time, but you can have multiple sqlldr processes running at once.

You can load from multiple files in a single control file only if the file layout is the same in each.
http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_control_file.htm#i1008015
sathya_mounika
Is there a better way to run mutiple sql loader processes at once than to open multiple command prompts? As said above, i will have to load 10 files into 10 different tables daily. Which means I have to manually run 10 sql loader processes daily manually.

Thanks
Brian Bontrager
Answer
Which operating system? ("Command Prompt" sounds like Windows)

UNIX/Linux: a shell script with multiple calls to sqlldr run in the background with "&" (and possibly nohup)

Windows: A batch file using "start" to launch multiple copies of sqlldr.
http://www.pctools.com/forum/showthread.php?42285-background-a-process-in-batch-%28W2K%29
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/start.mspx?mfr=true

Edited by: Brian Bontrager on May 31, 2013 4:04 PM
Marked as Answer by sathya_mounika · Sep 27 2020
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 10 2013
Added on Oct 13 2013
2 comments
283 views