Database Administration (MOSC)

MOSC Banner

Documentation & Feature Clarification for Specific v$sqlcommand CMD_TYPEs (Oracle 21c)

Specific Command Clarification Needed

We need the explicit SQL syntax for execution via SQL*Plus for the following CMD_TYPE entries found in v$sqlcommand. If a direct SQL statement is not available for any command, please provide an official statement to that effect and explain the technical reason for its inclusion in v$sqlcommand.

CMD_TYPE (from v$sqlcommand)

Clarification Required

CREATE BITMAPFILE

Exact SQL syntax needed.

CREATE PMEM FILESTORE

Exact SQL syntax needed (or reference to the correct DDL command).

UPSERT

Confirmation if a distinct UPSERT command exists, or if MERGE is the definitive implementation.

UPDATE JOIN INDEX

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center