TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Editors' Blog

Are Java's Days Numbered?

COBOL, Programming Language of the Future

RESTful Service Discovery Explained

Monitoring the Big Picture: A Modern Approach for Web Application Monitoring

Is OpenStack Truly the Linux of Cloud? Yes and No

Home » Tip Bank » Database Development » SQL » PL/SQL » SQL

Email Article
Comment on this Article
- Digg
- del.icio.us
- Newvine
- furl
- StumbleUpon
- BlinkList
- Newsvine
- Magnolia
- Facebook
- Tailrank
- Slashdot
- Technorati
- Google Bookmarks
- Yahoo Favorites
- Windows Live
- Ask

Language: Enterprise
Expertise: Beginner

May 16, 2000

Avoid Multiple Exit Points in a Function

If you have a database function that has multiple return statements, try to minimize the exit points. I will explain with the following example:

 create or replace function getStatus(p_status_code in varchar2)
	return varchar2 is 
begin
		if  	p_status_code =


														Jayanta Sengupta
														 
														
															
																
																	
																		
																			
																				
																			
																		
																		
																			Submit a Tip
																		
																		
																			
																				
																			
																		
																		
																			Browse "Database Development" Tips
																		
																		
																			
																				
																			
																		
																		
																			 Browse All Tips

0 Comments (click to add your comment)

Comment and Contribute

Sitemap