求一个存储过程。着急。在线等~~

Question

A表 和 B表是一对多的关系，给A表插一条数据。B表插10条数据。求存储过程实在没分了，大家见量，
求代码，

Answer 1

就是A表插一条记录。B表插10条。B表是A表的外键

Answer 2

A表的列的情况，B表列的情况如何根据A表的数据插入B表插入10条记录都是什么样的 这些都不说明白如何做

Answer 3

ID                   NUMBER(10)                             
NAME                 VARCHAR2(32)                           
NAME_IN_EMS          VARCHAR2(64) Y                         
TYPE                 NUMBER(2)                              
RATE                 NUMBER(2)    Y                         
DIRECTION            NUMBER(2)                              
STATUS               NUMBER(2)                              
WORK_MODE            NUMBER(2)                              
PARENT_SEG_ID        NUMBER(10)   Y                         
WAVE_ACCOUNT         NUMBER(2)    Y                         
PROTECT_TYPE         NUMBER(2)    Y                         
SERVICE_AREA_ID      NUMBER(10)                             
TRANS_TYPE           NUMBER(2)                              
A_DEVICE_TYPE        NUMBER(4)    Y                         
A_DEVICE_ID          NUMBER(10)                             
A_PORT_ID            NUMBER(10)                             
A_SERVICE_AREA_ID    NUMBER(10)                             
Z_DEVICE_TYPE        NUMBER(4)    Y                         
Z_DEVICE_ID          NUMBER(10)                             
Z_PORT_ID            NUMBER(10)                             
Z_SERVICE_AREA_ID    NUMBER(10)                             
TRANS_SUBNET_ID      NUMBER(10)   Y                         
TOPO_SUBNET_ID       NUMBER(10)   Y                         
SYSTEM_ID            NUMBER(10)   Y                         
PROTECTED_SEGMENT_ID NUMBER(10)   Y                         
A_ROOM               NUMBER(10)   Y                         
Z_ROOM               NUMBER(10)   Y

Answer 4

ID                   NUMBER(10)                              
DEVICE_ID            NUMBER(10)    Y                         
RACK_ID              NUMBER(10)    Y                         
SUBRACK_ID           NUMBER(10)    Y                         
SPECIALTY_TYPE       NUMBER(2)                               
CATEGORY             NUMBER(2)                               
MODEL                VARCHAR2(32)  Y                         
PANEL_NUM_TYPE       NUMBER(2)                               
FACTORY_ID           NUMBER(10)    Y                         
LOGIC_CODE           VARCHAR2(32)  Y                         
NAME                 VARCHAR2(64)  Y                         
ALIAS                VARCHAR2(64)  Y                         
FACTORY_CODE         VARCHAR2(32)  Y                         
TEMPLATE_TYPE        NUMBER(2)     Y                         
TEMPLATE_ID          NUMBER(10)    Y                         
TEMPLATE_MODIFY_FLAG NUMBER(2)     Y                         
USEFUL_LIFE          NUMBER(3)     Y                         
VERSION              VARCHAR2(100) Y                         
PROTECT_MODE         NUMBER(2)     Y                         
HEIGHT               NUMBER(7,3)   Y                         
WIDTH                NUMBER(7,3)   Y                         
DEPTH                NUMBER(7,3)   Y                         
MEASURE_UNIT         NUMBER(2)     Y                         
INSTALL_DATE         DATE          Y                         
DEPARTMENT_ID        NUMBER(10)    Y                         
PROJECT_ID           NUMBER(10)    Y                         
GOI_PROP_ASSET       NUMBER(10)    Y                         
GOI_PROP_LIFECYCLE   NUMBER(10)    Y                         
POS_X                NUMBER(7,3)   Y                         
POS_Y                NUMBER(7,3)   Y                         
POS_HEIGHT           NUMBER(7,3)   Y                         
POS_WIDTH            NUMBER(7,3)   Y                         
MEMO                 VARCHAR2(200) Y                         
SLOT_COUNT           NUMBER(3)     Y                         
PICTURE_ID           VARCHAR2(100) Y                         
UPPER_RES_TYPE       NUMBER(2)     Y                         
UPPER_ID             NUMBER(10)    Y                         
PANEL_NO             NUMBER(2)     Y                         
CODE                 VARCHAR2(32)  Y

Answer 5

是不是你不会 动态的 sql 啊.
要是你不会动态的SQL,我还可以做,要是你会,那就是你有别的需求
你的这些信息解决不了问题