Wednesday, 10 June 2026

Filled under:

INSERT ALL

  INTO host_check_table (hostname) VALUES ('server01')

  INTO host_check_table (hostname) VALUES ('server02')

  INTO host_check_table (hostname) VALUES ('server03')

SELECT 1 FROM dual;


COMMIT;



UPDATE your_table_name

SET details = NULL

WHERE hostname = 'server02';


COMMIT;



SELECT hostname, details
FROM your_table_name
WHERE hostname = 'server02';




SET LONG 1000000

SET LONGCHUNKSIZE 1000000

SET LINESIZE 300

COLUMN script_result FORMAT A200

0 comments:

Post a Comment