user3609422 user3609422 - 1 month ago 10
SQL Question

I need to add a table to a Oracle SQL database

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


I need two columns one that takes the current sysdate and the other to take a date

ALTER TABLE <TableName>
ADD (<Colum1> TO_DATE(SYSDATE, 'dd/mm/yyyy'), <Column2> TO_DATE('yyyy/mm/dd'));

Answer

Assuming that your current table's name is mytable, try this:

ALTER TABLE mytable ADD (current_date DATE DEFAULT SYSDATE, mydate DATE);