Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
odm_model_util.table_exist(p_table_name IN VARCHAR2) RETURN BOOLEAN;
BEGIN
IF odm_model_util.table_exist('SYS.TAB$') THEN
dbms_output.put_line('Exists');
ELSE
dbms_output.put_line('Not Found');
END IF;
END;
/
BEGIN
*
ERROR at line 1:
ORA-44003: invalid SQL name
ORA-06512: at "SYS.DBMS_ASSERT", line 190
ORA-06512: at "SYS.ODM_MODEL_UTIL", line 80
ORA-06512: at line 2
BEGIN
IF odm_model_util.table_exist('TAB$') THEN
dbms_output.put_line('Exists');
ELSE
dbms_output.put_line('Not Found');
END IF;
END;
/ Exists
There are multiple examples of Oracle not using the UPPER function ... but no available explanation as to why some developers feel compelled to reinvent the wheel.
odm_model_util.upcase(
p_out_name OUT VARCHAR2,
p_in_name IN VARCHAR2);
DECLARE
iVal dbms_id := 'Morgan';
oVal dbms_id;
BEGIN
odm_model_util.upcase(oVal, iVal);
dbms_output.put_line(oVal);
END;
/ MORGAN