Let us take a more detailed look at this code in the following table: Line(s) Description Instead, you just insert the UPDATE or SELECT into your code, as shown here:Ĩ WHERE author LIKE '%Critchley, Terry%' ġ1 'Terry has written (or co-written) ' ||ġ7 SET author = REPLACE(author,'Terry','Terrance')ġ8 WHERE author LIKE '%Critchley, Terry' You do not need to rely on any intermediate software such as ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity) to run SQL statements in your PL/SQL programs. One of the most important aspects of PL/SQL is its tight integration with SQL. The information you put in the parentheses must be a string value. Within a PL/SQL block, you can reference DBMS_OUTPUT.PUT_LINE and, in parentheses, provide the information you want to print to the screen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |