Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlcl describe alias

daniel_haukeFeb 5 2020 — edited Feb 19 2020

Hi everybody,

i know that i can create my own alias in sqlcl and that i can describe this alias with desc.

When i issue alias list <my_own_alias> it shows me the following in sqlcl:

SYS @ instance >alias list my_own_alias

my_own_alias - desc my_own_alias - Shows informations about the instance!

-------------------------------------------------------------------------------------------------------

select instance_name,host_name,status from v$instance

When i issue alias list on a build-in alias it shows the following:

SYS @ instance >alias list tables

tables - tables <schema> - show tables from schema

--------------------------------------------------

select table_name "TABLES" from user_tables

With my own alias the alias list command always shows the desc keyword. The build-in alias didn't contain this keyword.

Does anybody know a trick how i can get rid of the keyword desc when issuing the alias list command in sqlcl?

We are using SQLcl: Release 19.2.1

Greetings Daniel

This post has been answered by Gaz in Oz on Feb 18 2020
Jump to Answer

Comments

Post Details

Added on Feb 5 2020
8 comments
3,555 views