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 is Oracle Apps?
a suite of business software products from Oracle Corporation, encompassing various modules for managing different aspects of enterprise operations, including ERP, HCM, SCM, and more, both on-premises and in the cloud.
Trupti
0 0
5
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

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

Ask a Question

Related Lessons

Sub Queries in SQL(Structured Query Language)
Writing the Query in one more Query is called Sub Query. In Oracle SQl Sub Queries are Diveded into two categories Simple Sub Queries Cor-related Sub Queries The difference between Simple Sub Queries...

How To Create The Java Souce In Oracle PLSQL?
Requirement: How to find the list of files in specified directory? Step1 : First find the JDK Install or not in the oracle, to find jdk version please run the below sql. SELECT dbms_java.get_ojvm_property(PROPSTRING=>'java.version')...

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...

Interview questions on Packages in Oracle
Let me list few standard questions asked in the interviews on plsql package. 1. Why packages are used? What are it's advantages? 2. Name few bulin-in Oracle packages. 3. Can we have a function or procedure...

Steps to restore the OCR after OCR failure
1) OCR 1) Normal cluster filesystem 2) ASM diskgroup 1) Identify the manual or automatic OCR backups 2) Shutdown grid on all the nodes 3) ocrconfig -restore 4) restart the cluster...

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