Monday, 22 November 2021

Oracle : Display Arabic Character in the Linux Terminal sqlplus Prompt

 Set the NLS_LANG parameter and connect as sqlplus and execute the command.

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

sqlplus / as sysdba

<your sql select statement>

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...