Coco Beans
asked on
Database Global Variable
Hi,
Is there a way to set up a variable that is stored and used again and again in the database (Oracle). I want to set the financial Year to 2017. It's used over and over again in stored procedures and views etc... When it's changed, it should be changed in everything.
Like a global variable but where do you declare it etc...
Kind regards,
Caoimhe
Is there a way to set up a variable that is stored and used again and again in the database (Oracle). I want to set the financial Year to 2017. It's used over and over again in stored procedures and views etc... When it's changed, it should be changed in everything.
Like a global variable but where do you declare it etc...
Kind regards,
Caoimhe
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER