Macbook air m1

 Macbook Air M1:

1. Cannot install/upgrade any apps from app store. (after click, grey)

2. Can I set my Macbook Air to Do nothing When I close the lid?

3. Cannot develop as no JDK for M1 chip? - wait for VM?

Booked the session with specialist.

Bell Hub 3000 USB can only recognize NTFS format, cannot identify exFAT or MAC format.

For NTFS USB, mac is able to read/write, however it's very slow. It takes 14 mins to copy a 1.47Gb file from mac to the USB on Bell Hub 3000.

It takes 3 mins to copy the same file from the Bell Hub 3000 to mac.

It only takes 1 min to upload and download from google drive in my network (500M Fiber).

Oracle tidy DDL export

 

set serveroutput on

DECLARE

   V_DDL CLOB;

BEGIN

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'EMIT_SCHEMA',false);

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'PHYSICAL_PROPERTIES',false);

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',false);

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',false);

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', true);

   DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM, 'TABLESPACE',false);

   V_DDL := DBMS_METADATA.GET_DDL('TABLE', 'VIL_POSTED_TRANSACTION_RAW');

   DBMS_OUTPUT.PUT_LINE(V_DDL); 

END;