Question:
How do I insert a row into a long raw datatype
using a SQL inseert statement?
Answer: The
following SQL can be used to insert a row into a long raw
datatype column:
create table
test
(
c1 long raw
);
insert into test
values (utl_raw.cast_to_raw('hello world'));
After inserting into a long raw, you
need to use a
select a long raw datatype.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
