Find the best tutors and institutes for Oracle PL/SQL

Find Best Oracle PL/SQL

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Common mistake even experienced programmers make in Plsql.

Gavi Y.
21/12/2016 0 0

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 procedure proc1 (Name IN Varchar2(10)) AS.

What's wrong in this? Any guesses?

You should never write Varchar2(10) or Number(2) etc for parameters while creating procedure or function. It's an error.

Just write it like,

Create or replace procedure proc1 (Name IN Varchar2, Sal Number)  AS.

Even for the return type of a function.

Inside the declaration section of procedure or function or anonymous block, you should mention the size as Varchar2(20) or Number(3) or so. Otherwise, default size would be assumed depending on the type.

0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

What is DBMS and RDBMS
Database Management Systems A database is a collection of data or records. Database management systems are designed to work with data. A database management system (DBMS) is a software system that uses...

Amit Patil | 15 Apr

0 0
0

Big Data & Hadoop - Introductory Session - Data Science for Everyone
Data Science for Everyone An introductory video lesson on Big Data, the need, necessity, evolution and contributing factors. This is presented by Skill Sigma as part of the "Data Science for Everyone" series.

Skill Sigma | 21/12/2018

0 0
0

Database Origins
The need for a database originates from the fact that computers are dumb devices having batman like abilities which can be smartly be utilised by feeding it the right content. That is, for example, consider...
M

Manish Joshi | 20/07/2018

0 0
0

What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...

PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

Looking for Oracle PL/SQL ?

Find best Oracle PL/SQL in your locality on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
Sponsored

Find Best Oracle PL/SQL ?

Find Now »

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more