I need to add a table to Oracle SQL Database that takes current system time and I keep getting issues with:
"00907. 00000 - "missing right parenthesis"".
ALTER TABLE <TableName>
ADD (<Colum1> TO_DATE(SYSDATE, 'dd/mm/yyyy'), <Column2> TO_DATE('yyyy/mm/dd'));
Assuming that your current table's name is mytable, try this:
ALTER TABLE mytable ADD (current_date DATE DEFAULT SYSDATE, mydate DATE);