How to Resolve ORA-00999: invalid view name
ORA-00999 Tried to create a view for later use, but it failed with ORA-00999. Begin with Digit SQL> create view 123 as select * from… Read More »How to Resolve ORA-00999: invalid view name
Create View As Select (CVAS)
How to Resolve ORA-00905: missing keyword
ORA-00905 ORA-00905 is a very broadly used error message, any expected keyword missing from its statement will result in ORA-00905. These are only cases we… Read More »How to Resolve ORA-00905: missing keyword
How Oracle Change Column Order and Position
One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »How Oracle Change Column Order and Position