23 lines
1.4 KiB
SQL
Executable File
23 lines
1.4 KiB
SQL
Executable File
WHENEVER SQLERROR EXIT SQL.SQLCODE
|
|
SET DEFINE OFF
|
|
|
|
DELETE FROM dds_rag_chunks;
|
|
|
|
INSERT INTO dds_rag_chunks (chunk_id, document_title, department, classification, chunk_text, embedding)
|
|
VALUES (1, 'Benefits Policy', 'HR', 'INTERNAL', 'General benefits policy available to employees.', TO_VECTOR('[0.10,0.20,0.30]'));
|
|
|
|
INSERT INTO dds_rag_chunks (chunk_id, document_title, department, classification, chunk_text, embedding)
|
|
VALUES (2, 'Executive Compensation Plan', 'HR', 'HR_CONFIDENTIAL', 'Compensation calibration for executives and retention risks.', TO_VECTOR('[0.11,0.21,0.31]'));
|
|
|
|
INSERT INTO dds_rag_chunks (chunk_id, document_title, department, classification, chunk_text, embedding)
|
|
VALUES (3, 'Contract Renewal Risk', 'LEGAL', 'LEGAL_CONFIDENTIAL', 'Legal risk on renewal clauses for strategic accounts.', TO_VECTOR('[0.80,0.10,0.20]'));
|
|
|
|
INSERT INTO dds_rag_chunks (chunk_id, document_title, department, classification, chunk_text, embedding)
|
|
VALUES (4, 'Company Travel Guide', 'GENERAL', 'PUBLIC', 'Public travel and expense guidance for all employees.', TO_VECTOR('[0.20,0.70,0.10]'));
|
|
|
|
INSERT INTO dds_rag_chunks (chunk_id, document_title, department, classification, chunk_text, embedding)
|
|
VALUES (5, 'Board M&A Briefing', 'EXEC', 'EXECUTIVE_CONFIDENTIAL', 'Potential acquisition targets and board-level financial exposure.', TO_VECTOR('[0.90,0.20,0.40]'));
|
|
|
|
COMMIT;
|
|
SET DEFINE ON
|