Is Oracle PL/SQL tough to learn?

Asked by Last Modified  

Follow 2
Answer

Please enter your answer

I am online Quran teacher 7 years

PL/SQL is a powerful, yet straightforward database programming language.
Comments

I am a tutor since last 1 year

Learning Oracle PL/SQL can be relatively straightforward, especially if you already have a good grasp of SQL, as it builds upon that foundation with procedural programming features. While mastering advanced applications takes time, the initial learning curve is manageable.
Comments

No, basic learning if you know any langauge:1. Block programing2. Structure If else statement3. Loop : for, while ..4. Package , function , procedure , trigger.Advance programming:1. Collection :Associated Array, Nested loop , VARRAY(this is I never used in my 18yrs of exp)2. Dynamic SQL , execute immediate...
read more
No, basic learning if you know any langauge:1. Block programing2. Structure If else statement3. Loop : for, while ..4. Package , function , procedure , trigger.Advance programming:1. Collection :Associated Array, Nested loop , VARRAY(this is I never used in my 18yrs of exp)2. Dynamic SQL , execute immediate or DBMS_SQL3. Packages with Audit4. Pragma Automous TranscationThis is enough . 2 months learning curve for daily 2 hrs. read less
Comments

C language Faculty (online Classes )

Its database architectural principles are the same and it operates with SQL (Structured Query Language), plus Oracle's own PL/SQL extensions. It's relatively easy to learn — as long as you have a good handle on Linux and SQL. If you have already learned SQL Server, then you can certainly learn Oracle...
read more
Its database architectural principles are the same and it operates with SQL (Structured Query Language), plus Oracle's own PL/SQL extensions. It's relatively easy to learn — as long as you have a good handle on Linux and SQL. If you have already learned SQL Server, then you can certainly learn Oracle databases read less
Comments

View 2 more Answers

Related Questions

Hi, I would like to be a tutor. Please suggest how to proceed?
What is your educational qualification and what subject you are proficient, this depends on what you want to teach. If you have BEd degree, along wih your regular degree, then you can apply in schools also.
Geeta
What are the recommended study material to learn Oracle Database?
Hi Nirod..I recommend the Oracle Press books to all my students.. the Red and White paperback. They also have certification based trainings. They are many topics and tracks , depends on which topic, you...
Nirod
I have theoretical knowledge on PLSQL but I am not good in Hands-on PLSQL and how PLSQL works in a project, Can anyone help me?
it will great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively. If you’re brand new to PL/SQL, then you’ll want...
Kokila
What is oracle ACID?
In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions. In the context of databases, a sequence of database operations that satisfies...
Ramesh

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Common mistake even experienced programmers make in Plsql.
Hope, you are aware of Procedures in Plsql. Let us discuss one simple thing which we should always remember while writing the datatype of a parameter for a procedure or a function. Eg: Create or replace...

How To Prepare For OCA Exam?
Oracle Certified Associate certification programs are very costly to take the exam. They really deserve it because you get a high value of this certification in the job market. This Article is meant for...

How To Return a Result Set from a Stored Procedure
One of the easiest ways to tackle such Real Time scenarios is through use of Oracle Defined "SYS_REFCURSOR" or "REF CURSOR". We can create a Procedure with an out parameter of Type SYS_REFCURSOR and in...
S

New features of Oracle 23ai
2 of the new features of Oracle 23ai (previously Oracle 23c) with respect to SQL are discussed. 1. Boolean datatype included in SQL. Previously, boolean was not part of SQL, but belonged to Oracle...

SQL Subqueries - Used in various ways
If you master the concepts of subqueries, you would gain a lot of flexibility in writing complex SQL queries. Let's not get into Correlated subqueries, let us see the different versions of nested subquery...

Recommended Articles

Database Administration is the process building, organizing and maintaining custom databases for meeting the specific data requirements of an organization. A Database Administrator (DBA) is the person in charge of all the procedures involved in database development, organization, retrieval and security. A DBA has to understand...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Looking for Oracle Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you