You will use the WHERE clause of the UPDATE statement to restrict the update to a single row. The basic syntax is: INSERT, table name, column list, VALUES, and then a list of the values to be inserted.
The two hyphens in front of a line indicate that the line is a comment and the text will be ignored by the compiler.
You won't be able to load this easily using PLSQL natively.
Since TIFF is an ascii file -- there is a chance you could use UTL_FILE to read in the tiff file and then use UTL_RAW.
SQLException; // Oracle Specific JDBC classes: import *; import driver.*; public class linsert UPDATE Print_media SET ad_sourcetext = EMPTY_CLOB() WHERE product_id = 3060 AND ad_id = 11001; UPDATE Print_media SET ad_fltextn = EMPTY_CLOB() WHERE product_id = 3060 AND ad_id = 11001; UPDATE Print_media SET ad_photo = EMPTY_BLOB() WHERE product_id = 3060 AND ad_id = 11001; statement to update a row containing a LOB column by selecting a LOB from another table.
I need to insert data into it through insert statements.
Now that you have created the Products table, you are ready to insert data into the table by using the INSERT statement.
After the data is inserted, you will change the content of a row by using an UPDATE statement.
thanx sandy Ok, read_image_file should not page fault (for that, please contact support -- a tiff file is supported).