SQL*Plus alternatives?

[LuDaCriS66]

We're using Oracle and SQL*Plus for a database class and I'm hating having to have Oracle installed on my system... it adds an extra 300-400mb to my page file and its just really bloated..
If I try removing some parts of the software, I end up crippling SQL*Plus and it won't allow me to log in.

Anything I can use to simply type up my SQL assignments and be done with it?

 

[Mitzi]

We use TOAD though its pretty expensive however I think free-TOAD is still available somewhere.

 

[damiano]

sql navigator

 

[Haircut]

Yeah, either TOAD or SQL Navigator will do, I prefer TOAD personally.

This won't affect the 3-400 meg page file though, that is just because you have the Oracle server installed on your machine which takes a lot of memory.
TOAD will probably increase the total memory usage as it takes more memory than SQL*Plus and you still need Oracle on your system.

You can always disable the service when you are not using it though:
Go to Control Panel -> Administrative Tools -> Services

You should see a lot of Oracle services, the ones(s) which take up most memory will be called

OracleServiceSID of your database or something similar.
If you set this to manual then you can start it up as needed and not have all that memory usage.