79097436

Date: 2024-10-17 09:37:57
Score: 2
Natty:
Report link

@SimeonPilgrim appears to have the correct answer but it may also be worthwhile adding an UPDATED_BY, INSERTED_TIMESTAMP as well as the UPDATED_TIMESTAMP columns so you can better track changes in your table as is standard practice in S&P IHS Markit EDM (formerly CADIS) (ETL package used in financial services).

Something like this:

CREATE OR REPLACE TABLE T_EMPLOYEE( EMPLOYEE_ID INTEGER, TITLE VARCHAR(50), FIRST_NAME VARCHAR(100), LAST_NAME VARCHAR(100), SALARY DECIMAL(10, 2), INSERTED_TIMESTAMP TIMESTAMP DEFAULT CURRENT_TIMESTAMP(), UPDATED_TIMESTAMP TIMESTAMP DEFAULT CURRENT_TIMESTAMP(), UPDATED_BY VARCHAR(100) DEFAULT CURRENT_USER() );

INSERT INTO T_EMPLOYEE (EMPLOYEE_ID, TITLE, FIRST_NAME, LAST_NAME, SALARY) VALUES (1, 'DR.', 'Carrie', 'Madej', 100000);

SELECT * FROM T_EMPLOYEE;

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • User mentioned (1): @SimeonPilgrim
  • Low reputation (1):
Posted by: SnowPro_Engineer