I will post this into this group, because I think I can get here the most relevant answers. I'm beginner to Oracle, still exploring it and I have some questions regarding the accompanying tools, so I won't search for all this answers among all the docs:
- Soon or later you have to use SQLPlus or SQLcl (newer SQL Developer Command Line) and I would like to know if is worth to study SQLPlus at all or just skip it and dig into his successor SQLcl (if is at all) and learnt about it as much is possible?
- On Oracle download page you can download SQL Developer. Below is also link for separate download of SQLcl. Why this separate download link exist, regarding that (same) sql.exe is already contained in SQL Developer bin folder? Or is purpose of this link just for users who don't use SQL Dev but maybe some other GUI tool, like Toad?
- Does exist some useful functionalities only in SQLPlus and not in SQLcl anymore?
- What is main advantages of never SQLcl over SQLPlus?
- Does exist some users among us who's using just any of this tools and not SQL Dev at all and accomplish all what they need to? Here I have in mind also PL/SQL programming part and debugging?
- Which "must to have and know" tools you have to have in your toolbox for everyday work if you want to work professionally with Oracle database and APEX?
Thanks in advance for all your answers and tips.
BB