Relative Content

Tag Archive for sqloracleoracle-sqldeveloper

Creating Variable to Substitute in Table Name

I am working with table names that include the date in this format: “yyyymmdd” in SQL Developer. For example, a table will be called “OMR_CM.ccsi_mbr_id_did_20240314”. Currently, I have a variable that has to be changed each time the code is run to call the date. The variable is set with the script below:

New ‘Role’ column based on values

I am looking to have a new column created called ‘ Role’ to show the persons role in the company. People can change roles and the role is based on the cost centre and site they are at.