ORACLE 树形查询(connect by...start with...)的应用

最新推荐文章于 2024-08-14 11:43:40 发布

wengyupeng

最新推荐文章于 2024-08-14 11:43:40 发布

阅读量1k

点赞数

分类专栏： Database 文章标签： oracle insert integer table null 测试

112 篇文章 0 订阅

订阅专栏

Create table balance_sheet (BS_ID INTEGER ,BS_PID INTEGER ,BS_NAME VARCHAR2(100) ,BS_VALUE NUMBER(10) );

BS_ID 项目代码 BS_PID 项目父代码 BS_Name 项目名称 BS_VALUE 数据列

插入测试数据

insert into balance_sheet values(1,0,'流动资产',4256.45);

insert into balance_sheet values(2,1,'现金',2.00);

insert into balance_sheet values(3,1,'存放中央银行款项',160.77);

insert into balance_sheet values(4,1,'存放同业款项',18.34);

insert into balance_sheet values(5,1,'短期贷款', 4103.41);

insert into balance_sheet values(6,1,'其他流动资产',71.93);

insert into balance_sheet values(7,0,'长期资产',3287.75);

insert into balance_sheet values(8,7,'中长期贷款', 3262.89);

insert into balance_sheet values(9,7,'减：贷款呆账准备',73.71);

insert into balance_sheet values(10,7,'固定资产净值',77.58);

insert into balance_sheet values(11,7,'其他长期资产',20.99);

insert into balance_sheet values(12,0,'无形、递延及其它资产',0.52);

insert into balance_sheet values(13,0,'资产总计',7644.72);

insert into balance_sheet values(14,0,'流动负债',7453.74);

insert into balance_sheet values(15,14,'短期存款',305.54);

insert into balance_sheet values(16,14,'财政性存款',411.80);

insert into balance_sheet values(17,14,'向中央银行借款',6485.05);

insert into balance_sheet values(18,14,'同业存放款项',2.15);

insert into balance_sheet values(19,14,'其他流动负债',249.20);

insert into balance_sheet values(20,0,'长期负债',0.07);

insert into balance_sheet values(21,20,'发行长期债券',null);

insert into balance_sheet values(22,20,'其他长期负债', 0.07);

insert into balance_sheet values(23,0,'所有者权益',190.91);

insert into balance_sheet values(24,23,'其中：实收资本',165.15);

insert into balance_sheet values(25,0,'负债及所有者权益合计',7644.72);

commit;

显示全部数据：

select bs_name,bs_value from balance_sheet

connect by prior bs_id = bs_pid

start with bs_pid = 0

关注

专栏目录