upload file to oracle database
Hello, I am new to databases, I would like to be able to add a sql file to a field of an Oracle 19c database table:
I have done it this way but it gave me an error, I would like to know if it is the ideal way or if there are other ways:
[oracle@baseoracle ~]$ ls
Desktop Documents Downloads Music Pictures prueba.sql Public scripts Templates Videos
SQL> CREATE TABLE Archivos (
ID NUMBER PRIMARY KEY,
Nombre VARCHAR2(100),
Contenido BLOB
);
SQL> INSERT INTO Archivos (ID, Nombre, Contenido) VALUES (2, 'prueba.sql', EMPTY_BLOB());
1 row created.
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 7 18:59:42 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Tue May 07 2024 18:47:33 -05:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> DECLARE
v_blob BLOB;