oracleÖÐÅÐ¶Ï±í¡¢×ֶΡ¢Ë÷Òý¡¢Ö÷¼ü¡¢ÐòÁÐÊÇ·ñ´æÔÚ

ÅжϱíÊÇ·ñ´æÔÚ

function detect_table(str_in_tablename varchar2) return integer is
i_l_number integer;
begin
select count(*)
into i_l_number
from user_tables
where table_name = upper(str_in_tablename);

return i_l_number;
end;

ÅжÁ×Ö¶ÎÊÇ·ñ´æÔÚ

function detect_column(str_in_tablename varchar2, str_in_columnname varchar2) return integer is
i_l_number integer;
begin
select count(*)
into i_l_number
from user_tab_columns
where table_name = upper(str_in_tablename)
and column_name = upper(str_in_columnname);

return i_l_number;
end;

ÅжÏÖ÷¼üÊÇ·ñ´æÔÚ

function detect_constraint(str_in_tablename varchar2, str_in_constraint varchar2) return integer is
i_l_number integer;
begin
select count(*)
into i_l_number
from user_constraints
where table_name = upper(str_in_tablename)
and constraint_name = upper(str_in_constraint);

return i_l_number;
end;

ÅжÏË÷ÒýÊÇ·ñ´æÔÚ

function detect_index(str_in_tablename varchar2, str_in_indexname varchar2) return integer is
i_l_number integer;
begin
select count(*)
into i_l_number
from user_indexes
where table_name = upper(str_in_tablename)
and index_name = upper(str_in_indexname);

return i_l_number;
end;

ÅжÏÐòÁÐÊÇ·ñ´æÔÚ

function detect_sequence(str_in_sequencename varchar2) return integer is
i_l_number integer;
begin
select count(*)
into i_l_number
from user_sequences
where sequence_name = upper(str_in_sequencename);

return i_l_number;
end;