sql server stored procedure optional parameter code example

Example: sql stored procedure optional parameter

-- SQL Server
CREATE PROCEDURE MyProc 
	@Parameter VARCHAR (100) = 'DEF' 
AS ......

-- Oracle
CREATE PROCEDURE MyProc (Parameter IN VARCHAR2 DEFAULT 'DEF') 
AS ......