Convert numbers to words with and without decimal places - Crystal report

 Replace(ToWords({Table.Field}), 'and xx / 100', '')

ProperCase(Replace(ToWords({X_MODEL_TUSKER_SUP_1616IL1_REP.TERM}), 'and xx / 100', ''))

Delete login screen record from Toad Account

 --> To delete highlighted connection, when CTRL+ALT+DEL

Get Fiscal year from Current Date in Crystal Report

 IF Month ( CurrentDate ) <= 6

THEN ToText( Year ( CurrentDate ) - 1, 0, "" ) + '/' + ToText( Year ( CurrentDate ), 0, "" )

ELSE ToText( Year ( CurrentDate ), 0, "" ) + '/' + ToText( Year ( CurrentDate ) + 1, 0, "" )

enable/Disable archivelog in oracle database

 

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     90553

Current log sequence           90555

SQL> select log_mode from v$database;

LOG_MODE

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

NOARCHIVELOG

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 2516582224 bytes

Fixed Size                  9031504 bytes

Variable Size             587202560 bytes

Database Buffers         1912602624 bytes

Redo Buffers                7745536 bytes

Database mounted.

SQL> alter database archivelog;  (When Disable  --> alter database noarchivelog; )

Database altered.

SQL> alter database open;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE

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

ARCHIVELOG

SQL> select log_mode from v$database;