📄 longcolumn.out
字号:
A |C |D --------------------------------------------------------------------------------------------------------------------------------------------------------0 |1 |1 2 3 4 5 6 7 8 9 0 &1 |2 |a b c d e f g h i j &2 |3 |11 22 33 44 55 66 77 &3 |4 |aa bb cc dd ee ff gg &4 |5 |aa bb cc dd ee ff gg &5 |6 |aa bb cc dd ee ff gg &6 |7 |aa bb cc dd ee ff gg &7 |8 |aa bb cc dd ee ff gg &ij> -- update column b 10 timesupdate testing set b = PADSTRING('update 0', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 1', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 2', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 3', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 4', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 5', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 6', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 7', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 8', 64768);8 rows inserted/updated/deletedij> update testing set b = PADSTRING('update 9', 64768);8 rows inserted/updated/deletedij> -- select should return 8 rowsselect b from testing;B --------------------------------------------------------------------------------------------------------------------------------update 9 &update 9 &update 9 &update 9 &update 9 &update 9 &update 9 &update 9 &ij> select a, b, e from testing;A |B |E --------------------------------------------------------------------------------------------------------------------------------------------------------0 |update 9 &|2 1 |update 9 &|3 2 |update 9 &|4 3 |update 9 &|5 4 |update 9 &|6 5 |update 9 &|7 6 |update 9 &|8 7 |update 9 &|9 ij> -- drop the tabledrop table testing;0 rows inserted/updated/deletedij> -- test 7: table with 5 columns, all long columnscreate table testing (a clob(64768), b varchar(32384), c clob(64768), d varchar(32384), e clob(64768)) ;0 rows inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a',64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c',64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> insert into testing values (PADSTRING('a a a a a a a a a a', 64768), PADSTRING('b b b b b b b b b b',32384), PADSTRING('c c c c c c c c c c', 64768), PADSTRING('d d d d d d d d d d', 32384), PADSTRING('e e e e e e e e',64768));1 row inserted/updated/deletedij> -- select should return 10 rowsselect * from testing;A |B |C |D |E --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &a a a a a a a a a a &|b b b b b b b b b b &|c c c c c c c c c c &|d d d d d d d d d d &|e e e e e e e e &ij> select a from testing;A --------------------------------------------------------------------------------------------------------------------------------a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &a a a a a a a a a a &⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -