tag:blogger.com,1999:blog-7849367040589270673.post1372495434769253470..comments2024-03-21T22:50:39.997-07:00Comments on Obsessed with Oracle PL/SQL: The future of Oracle PL/SQL: some thoughts on Sten Vesterli's thoughtsSteven Feuersteinhttp://www.blogger.com/profile/18405765731886460622noreply@blogger.comBlogger46125tag:blogger.com,1999:blog-7849367040589270673.post-90510744158478659692018-10-15T06:31:30.424-07:002018-10-15T06:31:30.424-07:00Oracle moved into parallel processing architecture...Oracle moved into parallel processing architectures a long, long time ago and I expect we will support increasingly de-centralized models as well. But I have no specific light to shine about this right now.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-15279394316177353582018-10-13T18:29:27.255-07:002018-10-13T18:29:27.255-07:00Hi Steven,
I have working in Oracle for last 7 yea...Hi Steven,<br />I have working in Oracle for last 7 years. I am very much interested in working with "DATA".<br />I love writing SQL and PL/SQL code. I am continuously learning new stuffs in oracle. <br /><br />So far the only disadvantage I am seeing in Oracle is, that it could not handle the large volume of data (in terms of performance). I feel Oracle is best for OLTP systems. What about the future of oracle in Analytical systems ? Most of the time, I felt, why oracle is not moving into Parallel processing architecture ? Like MPP (Teradata), Node clusters (like AWS) ? etc..<br /><br />Rather having the database server as a centralized one, if it is converted into de-centeralized multiple parallel servers, it would be better. can you put some lights on this ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-17900331130689704752018-09-24T12:33:59.614-07:002018-09-24T12:33:59.614-07:00Sounds great! But I don't see it as a "fr...Sounds great! But I don't see it as a "from -- to" scenario. You are extending the reach of your PL/SQL knowledge to also build websites with APEX. That is a powerful, winning combination. I wish you the very best.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-42842643161905681452018-09-24T12:31:57.028-07:002018-09-24T12:31:57.028-07:00I am moving my career from PLSQL to Oracle ApexI am moving my career from PLSQL to Oracle ApexBhavanihttps://www.blogger.com/profile/09569579807560968375noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-66290627455590144172018-08-10T12:56:54.051-07:002018-08-10T12:56:54.051-07:00Robert, I tend to agree that it is relatively easy...Robert, I tend to agree that it is relatively easy to learn. However, evidence has shown that not many master the true power.<br />Richard Stevensonnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-5790680009257535162018-05-09T05:26:08.841-07:002018-05-09T05:26:08.841-07:00My prediction is: the javascript world will eat up...My prediction is: the javascript world will eat up a large chunk of the java world. But the need for SQL (and plsql) developers will even increase. Especially when the database will be the rest service provider (JSON) and the javascript world will be the rest consument. <br /> <br />Nowadays I see more an more Java developers starting to learn angular.js (because angular feels extremly close to Java).<br /><br />Plsql developers need to enhance their knowledge also to other technologies. Main reason is that with plsql alone you can not build a full application. You need at least some additional parts of the webstack (html, css, javascript). And APEX of cause.<br /><br />Now with MLE in the database we might see other langagues take over some part of the previous plsql domain. I still believe there is a need for plsql in the forseeable future. <br /><br /><br />Also I do see new young plsql developers. Often they started out learning Apex and now extent their knowledge to the database side.<br /><br />We live in interesting times.<br /><br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-60333264273976986432018-05-02T00:10:50.951-07:002018-05-02T00:10:50.951-07:00PL/SQL is the best programming language out there....PL/SQL is the best programming language out there. <br /><br />It is also very underrated. <br /><br />It's easy to learn and is basically a 4GL. <br /><br />You can concentrate on the business functions and logic rather than worry about frameworks and other stuff other languages like Java have.<br /><br />Rohanhttps://www.jwz.org/doc/java.htmlnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-66024440348487967832018-01-31T23:28:05.780-08:002018-01-31T23:28:05.780-08:00Great Post! Thanks for sharing.
Great Post! Thanks for sharing.<br />Nemcohttps://www.blogger.com/profile/02970834438322393091noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-63118389722552453882018-01-05T01:16:33.528-08:002018-01-05T01:16:33.528-08:00Hi Steven,
I've experience in plsql for 8 year...Hi Steven,<br />I've experience in plsql for 8 years, currently working in a project which is a sole project in my company for Kolkata, India Location, has Oracle plsql in backend. But I've to hear from my mangers and senior company personnels that changed or upgrade my skillset (especially for niche technology).<br /><br />But I want to stay in oracle and learn more plsql techniques. Please guide me, I'm getting confused day by day.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-57118881172058387412018-01-02T22:00:18.493-08:002018-01-02T22:00:18.493-08:00I really appreciated your suggestion for PL/SQL an...I really appreciated your suggestion for PL/SQL and Oracle APEX developer like me. There are many places where we must have to use javascript in APEX applications so as a APEX developer you should know javascript as well. Thanks.Anonymoushttps://www.blogger.com/profile/02487447932359115504noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-42204441368128794622017-12-07T10:48:40.739-08:002017-12-07T10:48:40.739-08:00For my part, I certainly love PL/SQL and see a wel...For my part, I certainly love PL/SQL and see a well-crafted Oracle application as a thing of beauty. Unfortunately, Oracle has lost us with their optimizer. Over and over again, we see random queries running just fine until one day without warning, and with no structural change in the database, and with only daily incremental increases in the amount of data in the underlying table, they go from 5 seconds to 2 hours. This has happened often enough that we are moving our high-performance applications off of Oracle and into a different architecture such as Redis or other in-memory tool. I don't really understand how the optimizer could be so bad; prior to Oracle 11, I never saw this kind of sudden performance tank. Yes I know you can freeze plans but it is quite complex and should not be necessary. Oracle should know how fast the query runs with different plans (especially when it picks a bad execution plan). When a query decrases speed by a factor of 100x, Oracle should be smart enough to revert to an earlier plan and see if it works better than the new one that it selected.<br /><br />And yes I know this is somewhat off-topic, but only marginally, because if Oracle was consistently high performing it would maintain a greater market share and this would lead to a greater popularity of all technologies Oracle.<br /><br />--Bill PribylAnonymoushttps://www.blogger.com/profile/01958915396893883770noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-16968936074015829052017-12-06T05:18:55.163-08:002017-12-06T05:18:55.163-08:00I am working as Oracle sql/plsql developer for las...I am working as Oracle sql/plsql developer for last 5 years, But I think as per salary is concerned Java and python programming language having high salary and Scope.<br />Company which are hiring they don't need so much experience developer for pl/sql they are more in BI and front end technologies. they acquire database developer having 2-3 years of experience. <br />Yes , I love the beauty of Oracle sql pl/sql and will try to find new jobs in that only.Jayant Sharmahttps://www.blogger.com/profile/09865364087464072549noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-11285681363017539252017-09-03T09:14:57.557-07:002017-09-03T09:14:57.557-07:00I am not sure I have much to add beyond my answers...I am not sure I have much to add beyond my answers to previous comments along these same lines. To summarize:<br /><br />1. Learn Oracle Application Express and some JavaScript to go with that.<br /><br />2. Make sure your SQL skills are sharp: analytic functions, pattern matching, ANSI joins.<br /><br />3. Get really good at building REST APIs with ORDS.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-91644687011081567752017-09-03T01:20:46.494-07:002017-09-03T01:20:46.494-07:00Hi Steve
I have now more than 10 years of experie...Hi Steve <br />I have now more than 10 years of experience in plsql working in India , given the problems occuring in IT market , what skills related to DB do you suggest me to learn or add to stay relevant in the coming times Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-26943178886925602952017-08-13T04:52:28.850-07:002017-08-13T04:52:28.850-07:00Golu, glad to hear you have some Java. I think it ...Golu, glad to hear you have some Java. I think it will be relatively rare in the coming years for anyone to just have backend database experience. You will need to handle more. I would look into Application Express and more than PL/SQL advanced techniques, build a very solid knowledge of SQL and advanced SQL. That will help you all OVER the place. Use the devgym.oracle.com site to build your skillset.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-20129071425087789752017-08-13T04:50:47.498-07:002017-08-13T04:50:47.498-07:00I would learn about ways to build APIs via PL/SQL ...I would learn about ways to build APIs via PL/SQL Packages and REST (ORDS) to provide to the .Net developers (that is, assuming their apps are running against Oracle). Open a line of communication with them about how the database experts on the team can and should "team up" with the UI developers to make sure their use of the database is optimal.<br /><br />Besides that, generally I suggest you broaden your knowledge: get basic familiarity with Java and JavaScript, definitely explore adding Application Express (which may have a brighter future than Oracle Forms).Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-10070894063668394082017-08-12T21:50:18.201-07:002017-08-12T21:50:18.201-07:00Hi Steven,
I work for a Government Client which h...Hi Steven,<br /><br />I work for a Government Client which has a Big oracle workshop(Systems) comprising oracle Forms, Reports, SQL and PL/SQL . The Oracle Forms(11G) Based Applications here are tightly integrated with backend pl/sql development and are running effectively since 20 years. <br />Since the recent years .NET Technologies Introduced here and are slowly replacing/building with .NET Technologies. Am an Oracle Developer 28 years old who has 5 Years of experience and has expertise in Forms,Reports,SQL and PL/SQL Development. What would you do if you were in my shoes? Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-1216618541805093982017-08-09T11:34:58.354-07:002017-08-09T11:34:58.354-07:00Hi Steven Sir,
I am following you since last 2 ye...Hi Steven Sir,<br /><br />I am following you since last 2 year in your practically perfect PL/SQL YouTube channel. <br /><br />I have 4 year experience in PLSQL, Oracle forms and Java as well, but I want to go with only PLSQL because I am perfect in PLSQL not like you just little bit, should I focus on other then PLSQL or concentrate only in PLSQL advance techniques. Please guide me. <br /><br />Bhavanihttps://www.blogger.com/profile/09569579807560968375noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-59100329569100157412017-08-09T05:50:24.864-07:002017-08-09T05:50:24.864-07:00Thanks for your thoughts. That comment in my In Bo...Thanks for your thoughts. That comment in my In Box was a nice way to start my day.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-19542211470194629652017-08-09T05:47:31.507-07:002017-08-09T05:47:31.507-07:00Hi Steven,
I still feel very positive about PL SQL...Hi Steven,<br />I still feel very positive about PL SQL and its future. some of the largest bank or the newer emerging banks around the globe still rely on ORACLE, and PL SQL to solve their mundane issues.May be in this new era, firms are adapting to EDB (Enterprise PostGres SQL based), still when it comes to scalability,reliability and data security, ORACLE still is at its apex.Anonymoushttps://www.blogger.com/profile/00897423740399714602noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-27124378214597791262017-07-24T05:28:31.673-07:002017-07-24T05:28:31.673-07:00I agree. PL/SQL is much easier to learn and write ...I agree. PL/SQL is much easier to learn and write than Java. The SQL inside it....perhaps more on par from a different perspective. Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-27925242313604719042017-07-22T14:56:12.111-07:002017-07-22T14:56:12.111-07:00I have 14 years of app development, mostly Java, J...I have 14 years of app development, mostly Java, J2EE and recently had to learn PL/SQL (I used Oracle and SQL before, but not so much PL/SQL). I found it fairly simple and small area to learn. So IMHO it is much easier to hire Java developer with basic SQL skills and train him PL/SQL then to hire PL/SQL and train him Java/.NET . Java on it's own is not that big... But adding frameworks, Spring, J2EE, some UI's frameworks,patterns, Hibernate... That's much bigger cake to eat. PL/SQL can be mastered within 6 months of intense learning and working with. IMHO it may be much harder to do same with Java and framework that works on it. So from enterprise applications standpoint PL/SQL is usually very small stack of technology used to run modern applications. If written in JAVA there is much bigger piece.MDhttps://www.blogger.com/profile/01718287858000118132noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-34784004609836954812017-04-17T04:06:41.415-07:002017-04-17T04:06:41.415-07:00This comment is a great way to start my week (it i...This comment is a great way to start my week (it is now Monday 6 AM). I am curious: did you actually "compete" with the other teams to produce that prototype? Did it involve refactoring mainframe applications?Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-20694780598671816542017-04-16T22:41:41.891-07:002017-04-16T22:41:41.891-07:00Hi,
I'm one of those manager who decided to g...Hi, <br />I'm one of those manager who decided to go ALL IN ( Apex, PLSQL, ORDS - in 2012 ).<br /><br />It was the best decesion I ever did. We are faster and cheaper then any Java, .net team. We have already a prototype ready when they are still thinking about the framework and java version they want to use.<br /><br />I hab to say - Oracle - PLSQL, Apex, ORDS Oracle is the best for refactoring COBOL, PL1, DB2 - mainframe applications, with focus on business logic, or were the logic is used in Online and Batch.<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-28190966075106554222017-03-30T09:37:08.557-07:002017-03-30T09:37:08.557-07:00Well, that's kind of the topic of this whole p...Well, that's kind of the topic of this whole post and the discussion swirling around it. I think it's a great idea. But it depends on your local market for jobs or whether it is possible to find remote work in the same.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.com