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...