Is it possible to get instance details similar to $(login) within schema?

Hi,

I would like to know the possibility of getting instance details within a schema similar to $(login). Idea is to add a default value in an attribute automatically based on instance value on inserting new records in a schema.I am keen to get a solution other than functions or storeprocedures that can be used within a schema

Thanks