功能:获得一个表或索引的数据定义语言(DDL)
程序: RSORATOOLS
参数:object :表名或是索引名
输出结果:例如MARA表
CREATE TABLE "SAPSR3"."MARA"
(
"MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"MATNR" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"ERSDA" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"ERNAM" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE,
"LAEDA" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"AENAM" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE,
"VPSTA" VARCHAR2(45) DEFAULT ' ' NOT NULL ENABLE,
"PSTAT" VARCHAR2(45) DEFAULT ' ' NOT NULL ENABLE,
"LVORM" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MTART" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"MBRSH" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MATKL" VARCHAR2(27) DEFAULT ' ' NOT NULL ENABLE,
"BISMT" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"MEINS" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"BSTME" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"ZEINR" VARCHAR2(66) DEFAULT ' ' NOT NULL ENABLE,
"ZEIAR" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"ZEIVR" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"ZEIFO" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"AESZN" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE,
"BLATT" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"BLANZ" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"FERTH" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"FORMT" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"GROES" VARCHAR2(96) DEFAULT ' ' NOT NULL ENABLE,
"WRKST" VARCHAR2(144) DEFAULT ' ' NOT NULL ENABLE,
"NORMT" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"LABOR" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"EKWSL" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"BRGEW" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"NTGEW" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"GEWEI" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"VOLUM" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"VOLEH" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"BEHVO" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"RAUBE" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"TEMPB" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"DISST" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"TRAGR" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"STOFF" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"SPART" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"KUNNR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
"EANNR" VARCHAR2(39) DEFAULT ' ' NOT NULL ENABLE,
"WESCH" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"BWVOR" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"BWSCL" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"SAISO" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"ETIAR" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"ETIFO" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"ENTAR" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"EAN11" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"NUMTP" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"LAENG" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"BREIT" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"HOEHE" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"MEABM" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"PRDHA" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"AEKLK" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"CADKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"QMPUR" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"ERGEW" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"ERGEI" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"ERVOL" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"ERVOE" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"GEWTO" NUMBER(3,1) DEFAULT 0 NOT NULL ENABLE,
"VOLTO" NUMBER(3,1) DEFAULT 0 NOT NULL ENABLE,
"VABME" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"KZREV" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"KZKFG" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"XCHPF" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"VHART" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"FUELG" NUMBER(3,0) DEFAULT 0 NOT NULL ENABLE,
"STFAK" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,
"MAGRV" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"BEGRU" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"DATAB" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"LIQDT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"SAISJ" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"PLGTP" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"MLGUT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"EXTWG" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"SATNR" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"ATTYP" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"KZKUP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"KZNFM" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"PMATA" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"MSTAE" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"MSTAV" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"MSTDE" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"MSTDV" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"TAKLV" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"RBNRM" VARCHAR2(27) DEFAULT ' ' NOT NULL ENABLE,
"MHDRZ" NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE,
"MHDHB" NUMBER(4,0) DEFAULT 0 NOT NULL ENABLE,
"MHDLP" NUMBER(3,0) DEFAULT 0 NOT NULL ENABLE,
"INHME" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"INHAL" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"VPREH" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,
"ETIAG" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"INHBR" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"CMETH" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"CUOBF" VARCHAR2(54) DEFAULT '000000000000000000' NOT NULL ENABLE,
"KZUMW" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"KOSCH" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"SPROF" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"NRFHG" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MFRPN" VARCHAR2(120) DEFAULT ' ' NOT NULL ENABLE,
"MFRNR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
"BMATN" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"MPROF" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"KZWSM" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"SAITY" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"PROFL" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"IHIVI" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"ILOOS" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"SERLV" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"KZGVH" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"XGCHP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"KZEFF" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"COMPL" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE,
"IPRKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"RDMHD" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"PRZUS" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MTPOS_MARA" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"BFLME" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MATFI" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"CMREL" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"BBTYP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"SLED_BBD" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"GTIN_VARIANT" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"GENNR" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"RMATP" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"GDS_RELEVANT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"WEORA" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"HUTYP_DFLT" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"PILFERABLE" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"WHSTC" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"WHMATGR" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"HNDLCODE" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"HAZMAT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"HUTYP" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"TARE_VAR" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MAXC" NUMBER(15,3) DEFAULT 0 NOT NULL ENABLE,
"MAXC_TOL" NUMBER(3,1) DEFAULT 0 NOT NULL ENABLE,
"MAXL" NUMBER(15,3) DEFAULT 0 NOT NULL ENABLE,
"MAXB" NUMBER(15,3) DEFAULT 0 NOT NULL ENABLE,
"MAXH" NUMBER(15,3) DEFAULT 0 NOT NULL ENABLE,
"MAXDIM_UOM" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"HERKL" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"MFRGR" VARCHAR2(24) DEFAULT ' ' NOT NULL ENABLE,
"QQTIME" NUMBER(3,0) DEFAULT 0 NOT NULL ENABLE,
"QQTIMEUOM" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"QGRP" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"SERIAL" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"PS_SMARTFORM" VARCHAR2(90) DEFAULT ' ' NOT NULL ENABLE,
"LOGUNIT" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"CWQREL" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"CWQPROC" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"CWQTOLGR" VARCHAR2(27) DEFAULT ' ' NOT NULL ENABLE,
"/BEV1/LULEINH" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
"/BEV1/LULDEGRP" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"/BEV1/NESTRUCCAT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"/DSD/VC_GROUP" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_TILT_IND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_STACK_IND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_BOT_IND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_TOP_IND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_STACK_NO" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"/VSO/R_PAL_IND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_PAL_OVR_D" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"/VSO/R_PAL_OVR_W" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"/VSO/R_PAL_B_HT" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"/VSO/R_PAL_MIN_H" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"/VSO/R_TOL_B_HT" NUMBER(13,3) DEFAULT 0 NOT NULL ENABLE,
"/VSO/R_NO_P_GVH" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE,
"/VSO/R_QUAN_UNIT" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"/VSO/R_KZGVH_IND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"MCOND" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"RETDELC" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"LOGLEV_RETO" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
"NSNID" VARCHAR2(27) DEFAULT ' ' NOT NULL ENABLE,
"IMATN" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"PICNUM" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"BSTAT" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
"COLOR_ATINN" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE,
"SIZE1_ATINN" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE,
"SIZE2_ATINN" VARCHAR2(30) DEFAULT '0000000000' NOT NULL ENABLE,
"COLOR" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"SIZE1" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"SIZE2" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"FREE_CHAR" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
"CARE_CODE" VARCHAR2(48) DEFAULT ' ' NOT NULL ENABLE,
"BRAND_ID" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"FIBER_CODE1" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"FIBER_PART1" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"FIBER_CODE2" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"FIBER_PART2" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"FIBER_CODE3" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"FIBER_PART3" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"FIBER_CODE4" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"FIBER_PART4" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"FIBER_CODE5" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
"FIBER_PART5" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
"FASHGRD" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
"ZZAGRI" VARCHAR2(3),
"ZZOWNBRAND" VARCHAR2(12),
"ZZCTART" VARCHAR2(3),
"ZZSEAART" VARCHAR2(3),
"ZZBOUART" VARCHAR2(3),
"ZZNEWART" VARCHAR2(3),
"ZZAOCTYPE" VARCHAR2(9),
"ZZSEASM" VARCHAR2(6),
"ZZSEAEM" VARCHAR2(6)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "PSAPSR3"
