![]() ![]() I tried every possible way but i still get "EMP_SALARY": invalid identifier.Ĭan anyone help me with this issue? Tables and columns are created successfully. NESTED TABLE EMP_SALARY STORE AS OYKUN_EMPSALARY Īfter i created the table i want to insert some data with code below INSERT INTO OYKUN_EMPLOYEE (EMPNO,EMP_NAME,EMP_ADDRESS,EMP_BIRTH_DATE,EMP_DEPARTMENT,EMP_MANAGER,EMP_SALARY) VALUESĮMP_NAME (OYKUN_TEMPORAL_VARCHAR('','','Ted Mosby')),ĮMP_ADDRESS (OYKUN_TEMPORAL_VARCHAR('','','Manhattan,New York')),ĮMP_DEPARTMENT (OYKUN_TEMPORAL_VARCHAR('','','Architect')),ĮMP_MANAGER (OYKUN_TEMPORAL_VARCHAR('','','Walter White')),ĮMP_SALARY (OYKUN_TEMPORAL_NUMBER('TO_DATE()','TO_DATE()',2500)) It was containing 'Instant Client - 11.2.0.1.0' in red. NESTED TABLE EMP_MANAGER STORE AS OYKUN_EMPMANAGER Oracle Error Code SQLCODE SQLSTATE Error Code Description ORA-00001-803. TOAD for Oracle Version 8.6 (Where the problem occured) PC2 (Machine OS: Windows XP SP2 TOAD for Oracle Version 8.6 (It works fine, easily connects to my database on Machine A) I want to work with TOAD and the Oracle Database Server 11g on the same machine. NESTED TABLE EMP_DEPARTMENT STORE AS OYKUN_EMPDEPARTMENT It also enables you to proactively identify potential issues and optimize SQL automatically. ![]() ![]() SQL Optimizer validates your database code to ensure the best-possible performance. NESTED TABLE EMP_ADDRESS STORE AS OYKUN_EMPADDRESS Toad for Oracle Xpert Edition provides you with all of Toad’s development, editing, debugging, and project management features, plus SQL Optimizer for Oracle. NESTED TABLE EMP_NAME STORE AS OYKUN_EMPNAME I created the table by this code CREATE TABLE OYKUN_EMPLOYEE( I need to help about the error code ORA-00904. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |