|-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是主键
解决方案 »
- 通过 约束名,如何查找外键约束的那张表?
- 根据期间条件和起始时间查询每年或每月的数据
- ORA-12154: TNS:无法解析指定的连接标志符和ERROR - ORA-12541: TNS:no listener 请问如何解决?
- mssql中的chrtran等同于oracle中的相应的函数
- CONVERT问题
- 产生了笛卡尔乘积,怎么解决.[在线给分]
- 如何获取oracle数据库中的所有用户名
- 新手求一函數
- 为什么记录集不能ADDNEW啊?
- SELECT 如何增加列
- 请问如何通过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)
经过算法生成的树,如何放进数据库