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