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
8 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.
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...
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...
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
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 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...
How does a SQL Query Execute inside Oracle? What are the steps followed in the background?
The above snapshot says it all. Hence it is said, 'Picture says it all'. Basically, there are 4-5 steps. There are two possible ways of query being executed. 1. Soft Parse- Improves performance....
SQL - Structured Query Language - DQL Commands - SELECT
Structured Query Language allows to store , manipulate, control and retrieve the information from Relational Database Management Systems. Following are some RDBMS products. Oracle Databse, Microsoft SQL...
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
