oracle 自动生成手机号码

  create or replace function my_mobile_num(
       v_content out varchar2
    )
    return varchar2
    is
    
    v_name1 nvarchar2(20);
    v_name2 nvarchar2(20);
     v_name3 nvarchar2(20);
    begin
    
          select name into v_name1 from (select * from mobile_num order by dbms_random.random) where rownum < 2  ;
          select substr(cast(dbms_random.value as varchar2(38)),3,4)  into v_name2  from dual;
          select substr(cast(dbms_random.value as varchar2(38)),3,4)  into v_name3  from dual ;
          
     v_content:=v_name1||v_name2||v_name3;
       return v_content;
    end;
    
    
    
    declare
       v_name1 varchar2(20);
    begin
       v_name1:=my_mobile_num(v_name1);--返回v_name值
       dbms_output.put_line(v_name1);--打印func结果
     end;