Home > database >  The oracle stored procedure parameters
The oracle stored procedure parameters

Time:10-01

A stored procedure, a parameter to the current date, now want to let this parameter as constants in the select statement, you can directly to the parameter name in the select statement?

CodePudding user response:

Ok, but I suggest you take the name of the individual

CodePudding user response:

 select v_day as day 
The from dual;

CodePudding user response:

No problem, just a similar to the SELECT statement has a default value

CodePudding user response:

Can, bold try, are you sure you can go beyond yourself

CodePudding user response:

Such changes have what meaning? What's the purpose?
People don't feel to good, because can modify the parameter in the call, as a condition not convenient,

  • Related