If oracle has been initialized, then on some operating systems, verify that oracle was linked correctly. Hi ranjan, you will have to write different insert statements for all column values as below. You tried to execute a sql statement that required two equal sets of values, but the second set contains fewer values than the first set. How to select 2 table record,add and insert into 3rd table between two dates using loop. Spool generated for class of oracle by satish k yellanki document generated by skyess techno solutions pvt. Hi, i have created a table with 2 columns and i have created the view as follows create view testview as select from testtable view is created successfully. Also, on the oracle technology forums, a user is reminded that in order to avoid ora 009, you have to keep in mind that you can update as many records as you want, as many as your undo can support. Ora 01035 oracle only available to users with restricted session privilege. The sql statement requires two sets of values equal in number. The 009 message indicates that the record which you are trying to send to oracle includes more columns than were included at the time the table was created. Yes, there is an insert statement based on the results fectching from this query. For queries and live project experience in any domain.
337 523 1342 933 902 1143 190 368 949 609 833 47 1019 258 1537 383 1264 481 1077 1541 653 1585 911 155 736 752 282 450 888 736 771 127