AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Change sql prompt10/12/2023 There are many predefined user variables in Oracle Database sqlplus / as sysdbaĭEFINE _CONNECT_IDENTIFIER = "ORA12C" (CHAR)ĭEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR)ĭEFINE _O_VERSION = "Oracle Database 12c EnterpriseĮdition Release 12.1.0.2.0 - 64bit Production ![]() This article shows how you can enhance it using sqlplus command SET SQLPROMPT and predefined user variables. Default sqlplus prompt is very simple once you connect to a database.
0 Comments
Read More
Leave a Reply. |