ora-00905
how to find length of a Long Column in a table
I have a LONG column named FileSize in a table called Files. To achieve the objective, I did the following :[详细]
2023-02-19 10:56 分类:问答Getting ORA-00905 error when trying to add a foreign key
I\'m trying to perform the following statement into oracle: alter table COMENTARIO add constraint FK_COMENTARIO_DI foreign key (DI_ID)[详细]
2023-02-01 22:05 分类:问答Using the Oracle "at time zone" function in sql - problem and solution
I have a table with a date column that I know is stored in GMT.I have a procedure that accepts a date input and an account ID.The procedure:[详细]
2023-01-24 09:30 分类:问答Problem with an SQL statement
I\'m having a problem with an SQL statement. I want to activate a \"ON UPDATE CASCADE\" behavior for a foreign key in a table with this statement :[详细]
2023-01-19 06:50 分类:问答SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
Asking for your help on this Oracle query. It\'s giving me the error 2 \"ORA-00905: missing keyword\". It was working fine before I added the LEFT JOIN statement. Obviously it won\'t deliver the infor[详细]
2022-12-25 18:19 分类:问答GWT test with external server
I have a server-code that\'s written in Python, and I have a client-code that\'s written with GWT. Now I want to run automation testing on the GWT against the data from the Python server.[详细]
2022-12-16 19:13 分类:问答