|-aaa
|----bb
|--------ll
|----cc
|--------hh
|--------kk
|-dd
|----ee
|----ff
如何将上边这个树型的数据存入ORCLAE数据库表中.
小弟设计了一下表,就是不知道怎么将数据放进去.
表中最初没有数据,现在要将整个树型数据全部存到这个表中.
请高手帮帮忙,分不够可以加!
id paretnId text id是主键
|----bb
|--------ll
|----cc
|--------hh
|--------kk
|-dd
|----ee
|----ff
如何将上边这个树型的数据存入ORCLAE数据库表中.
小弟设计了一下表,就是不知道怎么将数据放进去.
表中最初没有数据,现在要将整个树型数据全部存到这个表中.
请高手帮帮忙,分不够可以加!
id paretnId text id是主键
解决方案 »
- oracle的SMJ,NL和HJ
- 关于查看控制文件信息的问题
- Orcle的查询语句优化.
- Oracle insert into sys.tsm_department权限不够
- 商务智能的探讨
- 有关于系统中一些状态、类型字段这样来设计有道理吗?值得推荐吗?大家来看看
- 晕:system居然能修改sys的密码,是什么地方出问题了?郁闷。。。。。。。。。。。。。。。
- 两个字段相加作为另一个字段,在Orcale怎么写?在SQl server是这样:select d1,d2,(d1+','+'d2) as d3 from 表1,但在orcale中通不过
- 问题追加30分
- 有谁知道oracle9i在p4机器上安装是否有什么文件需要修改?
- 请问如何通过jdbc得到oracle的rowid
- oracle 9i WE8ISO8859P1 字符集 Oracle odbc驱动,汉字乱码的问题,加急!
|----bb
|----ll
|----cc
|----hh
|----kk
|-dd
|----ee
|----ff
这个树型应该比较清楚!
id name fatheid
1 aa 0
2 bb 0
3 cc 0
4 dd 1
5 ee 1
6 ff 2
7 gg 5
8 hh 6这样就可以了
说清楚一点
SQL> select * from tree_table; CID CNAME FID
---------- ----- ----------
1 aaa 0
2 bb 1
3 ll 2
4 cc 1
5 hh 4
6 kk 4
7 dd 0
8 ee 7
9 ff 79 rows selected
SQL> select level,
2 cid,
3 fid,
4 '|'||lpad('-',level*2-1,'-')||cname as new_cname
5 from tree_table tt
6 connect by prior cid = fid
7 start with cname = 'aaa'
8 ; LEVEL CID FID NEW_CNAME
---------- ---------- ---------- --------------------------------------------------------------------------------
1 1 0 |-aaa
2 2 1 |---bb
3 3 2 |-----ll
2 4 1 |---cc
3 5 4 |-----hh
3 6 4 |-----kk6 rows selected
1 aaa 0 0
2 bb 1 1
3 cc 1 1
4 dd 0 0
5 ee 4 1
6 ff 4 1
7 hh 3 2
8 kk 3 2
9 ll 2 2其实最后一个cowid可以不要,只要和上级关联就可以了
1 1 0 |-aaa
1 2 1 |---bb
1 3 2 |-----ll
1 4 1 |---cc
1 5 4 |-----hh
1 6 4 |-----kk
2 1 0 |-aaa
2 2 1 |---bb
2 3 2 |-----ll
2 4 1 |---cc就两棵树!
¦ object = cfg_: ok (99.0)
¦ object = scripte: ok (71.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: or (56.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = billing2
¦ object = cfg_: ok (99.0)
¦ object = scripte: ok (71.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: or (56.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = jfsys
¦ opt = vi/wq: ok (0.0)
¦ opt = execute: ok (0.0)
¦ opt = select/insert/update: ok (60.0)
¦ opt = null: ok (0.0)
¦ opt = insert/update: ok (90.0)
¦ opt = insert
¦ ¦ object = cfg_: ok (0.0)
¦ ¦ object = scripte: ok (0.0)
¦ ¦ object = PM_*_table: ok (14.0)
¦ ¦ object = null: ok (0.0)
¦ ¦ object = _file: ok (0.0)
¦ ¦ object = DR_*_table: ok (14.0)
¦ ¦ object = SUM_*_table: ok (14.0)
¦ ¦ object = ACC_*_table: ok (44.0)
¦ ¦ object = _table: or (14.0)
¦ opt = vi: ok (0.0)
¦ opt = wq: ok (0.0)
¦ opt = select
¦ ¦ object = cfg_: or (0.0)
¦ ¦ object = scripte: or (0.0)
¦ ¦ object = PM_*_table: ok (14.0)
¦ ¦ object = null: or (0.0)
¦ ¦ object = _file: or (0.0)
¦ ¦ object = DR_*_table: ok (14.0)
¦ ¦ object = SUM_*_table: or (14.0)
¦ ¦ object = ACC_*_table: or (14.0)
¦ ¦ object = _table: or (14.0)
¦ opt = update
¦ ¦ object = cfg_: ok (0.0)
¦ ¦ object = scripte: ok (0.0)
¦ ¦ object = PM_*_table: ok (14.0)
¦ ¦ object = null: ok (0.0)
¦ ¦ object = _file: ok (0.0)
¦ ¦ object = DR_*_table: ok (14.0)
¦ ¦ object = SUM_*_table: ok (14.0)
¦ ¦ object = ACC_*_table: or (14.0)
¦ ¦ object = _table: ok (14.0)
¦ opt = delete: or (70.0)
¦ opt = drop: or (70.0)
¦ opt = truncate: or (70.0)
account = mdb1: or (422.0/2.0)
account = mdb2: or (422.0/2.0)
account = root
¦ object = cfg_: or (342.0)
¦ object = scripte: or (228.0)
¦ object = PM_*_table: or (0.0)
¦ object = null: ok (60.0)
¦ object = _file: or (229.0)
¦ object = DR_*_table: or (0.0)
¦ object = SUM_*_table: or (0.0)
¦ object = ACC_*_table: or (0.0)
¦ object = _table: or (0.0)
account = billing5
¦ object = cfg_: or (90.0)
¦ object = scripte: ok (75.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: ok (75.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = billing6
¦ object = cfg_: or (90.0)
¦ object = scripte: ok (75.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: ok (75.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = billing3
¦ object = cfg_: ok (105.0)
¦ object = scripte: ok (75.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: or (60.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = billing4
¦ object = cfg_: ok (105.0)
¦ object = scripte: ok (75.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: or (60.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = jf
¦ opt = vi/wq: or (0.0)
¦ opt = execute: or (0.0)
¦ opt = select/insert/update: ok (30.0)
¦ opt = null: or (0.0)
¦ opt = insert/update: ok (90.0)
¦ opt = insert
¦ ¦ object = cfg_: ok (0.0)
¦ ¦ object = scripte: ok (0.0)
¦ ¦ object = PM_*_table: or (14.0)
¦ ¦ object = null: ok (0.0)
¦ ¦ object = _file: ok (0.0)
¦ ¦ object = DR_*_table: ok (14.0)
¦ ¦ object = SUM_*_table: ok (14.0)
¦ ¦ object = ACC_*_table: ok (44.0)
¦ ¦ object = _table: or (14.0)
¦ opt = vi: or (0.0)
¦ opt = wq: or (0.0)
¦ opt = select
¦ ¦ object = cfg_: or (0.0)
¦ ¦ object = scripte: or (0.0)
¦ ¦ object = PM_*_table: or (14.0)
¦ ¦ object = null: or (0.0)
¦ ¦ object = _file: or (0.0)
¦ ¦ object = DR_*_table: ok (14.0)
¦ ¦ object = SUM_*_table: or (14.0)
¦ ¦ object = ACC_*_table: or (14.0)
¦ ¦ object = _table: or (14.0)
¦ opt = update
¦ ¦ object = cfg_: ok (0.0)
¦ ¦ object = scripte: ok (0.0)
¦ ¦ object = PM_*_table: or (14.0)
¦ ¦ object = null: ok (0.0)
¦ ¦ object = _file: ok (0.0)
¦ ¦ object = DR_*_table: ok (14.0)
¦ ¦ object = SUM_*_table: ok (14.0)
¦ ¦ object = ACC_*_table: or (14.0)
¦ ¦ object = _table: ok (14.0)
¦ opt = delete: or (70.0)
¦ opt = drop: or (70.0)
¦ opt = truncate: or (70.0)
account = jhz1
¦ object = cfg_: ok (204.0)
¦ object = scripte: ok (146.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: or (116.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = jhz2
¦ object = cfg_: ok (204.0)
¦ object = scripte: ok (146.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: or (116.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = billing8
¦ object = cfg_: or (84.0)
¦ object = scripte: ok (71.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: ok (71.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
account = billing7
¦ object = cfg_: or (84.0)
¦ object = scripte: ok (71.0)
¦ object = PM_*_table: ok (0.0)
¦ object = null: ok (0.0)
¦ object = _file: ok (71.0)
¦ object = DR_*_table: ok (0.0)
¦ object = SUM_*_table: ok (0.0)
¦ object = ACC_*_table: ok (0.0)
¦ object = _table: ok (0.0)
经过算法生成的树,如何放进数据库