Which to choose first
Developer, October 26, 2015 - 5:41 am UTC
Which language should I choose first Java or pl/sql.
Will pl/sql is going to be in streamline for long time.
Who has more demand between these two.
October 27, 2015 - 11:39 am UTC
It's up to you.
If you're learning programming from scratch, PL/SQL is easier. Java is an object oriented language, which adds complexity.
PL/SQL will be around as long as the Oracle database exists.
If you want to compare popularity, check the TOBIE programming index:
http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html
Which one should i go
Dev, October 27, 2015 - 5:43 am UTC
Which one should I go as a startup of my carrier.
Which of between this two has more demands in trems of opening and scope....
October 27, 2015 - 11:43 am UTC
See my response to the previous review.
Another option
John Gasch, October 27, 2015 - 5:50 pm UTC
May I suggest a third option to consider? Learn SQL - learn how to develop solutions to problems efficiently.
A software developer is not only a coder, but should also be a problem solver. Java and PL/SQL are programming languages. When confronted with a problem to solve, there may be many ways to approach it, but only few of those would be considered the 'best' approach.
Junior developers are often eager to write lots of procedural code, using the database as a data-store, when such logic could better be embedded in SQL, and likely run orders of magnitude faster with far fewer lines of code to maintain.
Learning SQL is more than knowing the syntax and understanding how to do the various joins, and having a cursory awareness of analytic functions. Rather, really learning SQL is understanding how to decompose a problem and map a solution using relational logic. It is knowing how to use all of the tools in the SQL toolbox, and how to effectively apply those tools. And, a most valuable skill is knowing how to build a problem-solver that will run efficiently.
October 27, 2015 - 9:41 pm UTC
Excellent points.
Yes,Point suggested is great...
Dev, October 28, 2015 - 5:46 am UTC
Yes,Point suggested is great.Indeed I have started from SQL.
but my main doubt was that if I go with pl/sql is there any chances that demand for it would be declining or out of streamline.
Cause java I know no competition with it.
October 28, 2015 - 6:26 pm UTC
An easy proof of that - go to www.oracle.com/openworld and check all the sessions that refer to PLSQL. Its here to stay.
But no reason why you should not be skilled in both.
Hope this helps.
And you can even do Web development with a little PL/SQL...
Joel, January 14, 2016 - 12:15 pm UTC
Let's not forget - you can build beautiful and modern Web applications with just a little knowledge of SQL and PL/SQL. It's called Oracle Application Express (APEX). Even DBAs can and do use it.
After all, the system you're using now, AskTom, is written in Oracle Application Express!
January 15, 2016 - 1:15 am UTC
Indeed.