Why does for update in oracle 8 cause an ora-01002 error?
Answer / Arun Kumar Bhashkar
In Oracle 8, the FOR UPDATE clause is not supported in SELECT statements. This leads to ORA-01002: fatal error encountered during execution of a PL/SQL statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Name the three major set of files on disk that compose a database in Oracle?
What are group functions in oracle?
What privilege is needed for a user to create tables in oracle?
how will I find the first 5 highest salaried employees in each dept in oracle.
can u call user defined functions in select statements
What is Database Link ?
Can we protect our pl/sql source code?
Explain oracle 12c new features for developers?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
How to find no of saturdays in a month using single sql ?
How many file formats are supported to export data?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?