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 Kokila Last Modified
Follow 1 
Answer 
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.
7
Comments
Try Oracle apps and try to do a small project,that will boost your confidence
1
Comments
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.
0
Comments
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.
0
Comments
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.
0
Comments
I'm providing real time projects, call me if you need, my training will be based purely on real time basis.
0
Comments
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
0
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
0
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...
15 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...
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.
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated 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
