Question

Insert statement for long raw and raw

Rating9.2Excellent

How to insert data into long raw and raw datatype in table?

create table demo(t1 raw,t2 long raw);
I want a insert statement for inserting into demo tables?

  1. Assign data from BLOB field to LONG RAW data
    I have this situation: - Table A: ID_COLECTOR NUMBER (9) NOT NULL, NOMBRE_COLECTOR VARCHAR2 (20), ARCHIVO LONG RAW, ES_BACKUP NUMBER, FECHA DATE, GENERAR_DBFS INTEGER - Table B: ID_COLECTOR NUMBER (9) NOT NULL, ARCHI…
  2. Convert jpeg file to long raw inside an Oracle dat…
    I have an Access database; it contains an identification number and the path to a jpeg file. This jpeg file is a photo. I want to take the identification number (from access) and select the row from a table inside an Oracle database that matches the identifaction number. I then want to insert the jpeg file into the table column that is defined as long raw for this …
  3. Copying a Long Raw column
    We had to perform maintenance on a table with long raw data. We tried export/import but since the table was pretty big, (74 Gb, unpartitioned) it was taking way too much time ... CTAS doesn't work on Long columns so we used copy command to create a new table with the recent data ... It went fine but some of the data when opened later t…
  4. oracle insert statement
    I have to pass $value to the insert statement in oracle in a Perl script. But the values to be passed have to be in single quotes. But is I pass $value has to be in double quotes for string interpolation . Please advise how can I do that.
  5. PL\SQL insert a raw
    Hi All How it is possible to insert a whole raw (stored in to the %ROWTYPE variable into table (which have the same names and types of columnsa as in the table)? . . my_raw adam2%ROWTYPE; . . . my_raw.ID =4; instruction_insert :=' INTO adam2 VALUE my_raw'; EXECUTE IMMEDIATE instruction_i…

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
insert
Participating Experts
5
Solution Grade
A

Replies

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: oraelbis

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Mindphaser

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: DanRollins

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Moondancer

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert