My Oracle Support Banner

SQLcl "INFORMATION" or "INFO" Command Incorrectly Shows Primary Key Columns (Doc ID 2977529.1)

Last updated on OCTOBER 03, 2023

Applies to:

Oracle SQLcl - Version 22.3 and later
Information in this document applies to any platform.

Symptoms

Using SQLcl to retrieve object information using "INFO" command shows incorrect Primary Key columns. In below testcase both F_A, F_B columns shows as indexed

NOTE: The sample program in this article is provided for educational purposes only and is NOT supported by Oracle Support Services. It has been tested internally and works as documented. Oracle can not guarantee that it will work in all possible configurations, so be sure to test it thoroughly in your test environment before deploying it.

Test Case

Changes

 Using latest SQLcl 23.2

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.