21 lines
495 B
SQL
Executable File
21 lines
495 B
SQL
Executable File
WHENEVER SQLERROR EXIT SQL.SQLCODE
|
|
|
|
BEGIN
|
|
EXECUTE IMMEDIATE q'[
|
|
CREATE TABLE dds_rag_chunks (
|
|
chunk_id NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
|
|
document_title VARCHAR2(160) NOT NULL,
|
|
department VARCHAR2(40) NOT NULL,
|
|
classification VARCHAR2(30) NOT NULL,
|
|
chunk_text VARCHAR2(1000) NOT NULL,
|
|
embedding VECTOR(3, FLOAT32)
|
|
)
|
|
]';
|
|
EXCEPTION
|
|
WHEN OTHERS THEN
|
|
IF SQLCODE != -955 THEN
|
|
RAISE;
|
|
END IF;
|
|
END;
|
|
/
|