1. Oracle AI Vector Search User's Guide
  2. Store Vector Embeddings
  3. Create Tables Using the VECTOR Data Type
  4. Vectors in External Tables
  5. Querying an Inline External Table

Querying an Inline External Table

In this example, vectors in an external table of type ORACLE_BIGDATA are queried as part of a vector search. 

select * from external (
    (
      COL1 vector,
      COL2 vector,
      COL3 vector,
      COL4 vector
    )
    TYPE ORACLE_BIGDATA
    DEFAULT DIRECTORY DEF_DIR1
    ACCESS PARAMETERS
    (
      com.oracle.bigdata.credential.name\=OCI_CRED
      com.oracle.bigdata.credential.schema\=PDB_ADMIN
      com.oracle.bigdata.fileformat=parquet
      com.oracle.bigdata.debug=true
    )
    location ( 'https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/myvdataproject/BIGDATA_PARQUET/vector_data/basic_vector_data.parquet' )
    REJECT LIMIT UNLIMITED
  ) tkexobd_bd_vector_inline;

Parent topic: Vectors in External Tables