user3609422 user3609422 - 4 months ago 29
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

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);