user3609422 user3609422 - 1 year ago 98
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'));

Answer Source

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

ALTER TABLE mytable ADD (current_date DATE DEFAULT SYSDATE, mydate DATE);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download