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?

Asked by Last Modified  

29 Answers

Follow 1
Answer

Please enter your answer

MS SQL SERVER DBA Trainer

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 to take some time to get familiar with the language.
Comments

Excel VBA Expert

Try Oracle apps and try to do a small project,that will boost your confidence
Comments

Database Trainer

Go to above URL, its a cloud based DB. which has all environment ready. All you need to do is create an account for yourself and start working with hands-on with the scripts you have theoretically. For more details on Real time different types of project in markets, Kindly send a note.
Comments

Trainer

Hi Kokila, You need to have at least hands on experience in PL-SQL to have complete understanding of PLSQL. This can be done by practicing some small small programs related to pl-sql concepts like procedures/functions/packages/triggers/cursors/loops etc. I hope I answered your question.
Comments

Oracle Plsql Trainer

yes
Comments

Sr Software developer

yes can help you on this.
Comments

Oracle PL SQL Trainer for Engg.Graduates and Job Seekers

Hi.. PL SQL used in project is different from the theoretical knowledge. You should also learn advanced DS and Performance related to it. Kindly contact me for details.
Comments

Oracle Trainer

I'm providing real time projects, call me if you need, my training will be based purely on real time basis.
Comments

Database, Coding ,AWS Cloud Trainer and Mentor

Not much scope in being PLSQL developer. In the long run either you have to choose oracle dba or oracle Apps developer. If interested for DBA get in touch with me
Comments

PL/SQL plays Key role in Oracle DB. And PL/SQL depends on SQL Queries for Data retrieving. Most of the projects which are having Oracle DB then then the business Logic will be in DB using PL/SQL. So it will be difficult if you are weak in PL/SQL. For complex business logic, requires efficient coding...
read more
PL/SQL plays Key role in Oracle DB. And PL/SQL depends on SQL Queries for Data retrieving. Most of the projects which are having Oracle DB then then the business Logic will be in DB using PL/SQL. So it will be difficult if you are weak in PL/SQL. For complex business logic, requires efficient coding which should be good in performance wise also. If you are good in PL/SQL then only can do coding with performance effective sql statement. read less
Comments

View 27 more Answers

Related Questions

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
Oracle is best in market as teradata ?
It depends in your Interest.
Ganesh
0 0
8
Hi what is the Normalization? and the types?
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than...
Anant
Do ORACLE/PLSQL is having scope in IT industry ? is it use full for a IT career?
Its depend in your choice. But MS SQL more prefer compare to Oracle.
Krishna

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

Ask a Question

Related Lessons

Oracle Architecture - Introduction
As a Oracle developer or a DBA, you should know the in & out of it’s Architecture. Let’s keep it simple first and explore later. Oracle is a software or a program, so like any other program,...

Introduction to Performance tuning
What is Performance in general terms? Throughput per Input. For Eg: we keep saying, this bike has so and so much of mileage and all that. That is one of the parameters in measuring the performance of...

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

Exception Handling topics
Here, I am only going to list the topics which one should consider to master Exception Handling. 1. Types of errors in Pl/sql- Compile time and Run time 2. How to read and understand the Compile time...

Interview questions based on "level", a pseudocolumn
1. Write a query to get the below output, 1 11 21 31 .. .. 91 2 12 22 32 .. .. 92 3 13 23 33 .. .. 93 .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. 10 20 30 40 ...
Find Oracle PL/SQL near you

Looking for Oracle PL/SQL ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you