Interesting SQL (3)

zhaozj2021-02-16  78

Several display results are very interesting SQL.

?

Reposted from the column from Lunar2000 http://blog.9cbs.net/lunar2000/?

?

?

A huge friendship tree http://blog.9cbs.net/lunar2000/Archive/2004/07/26/51714.aspx

SQL> SET PAGESIZE 2000SQL> SELECT DECODE? 2 ???????? (Sign (MaxWidth * 2) -rownum)? 3 ?????????, 1, lpad ('', floor) MaxWidth * 2) - (ROWNUM-1))? 4 ??????????? || RPAD ('*', 2 * (ROWNUM-1) 1, '*')? 5??? ??????, lpad ('* * * ", floor (maxwidth * 2) 3))? 6? from all_Objects? 7 ????, (SELECT 20 AS MAXWIDTH from DUAL)? 8? Where Rownum < FLOOR (MAXWIDTH * 2) 5;

???????????????????????????????? * ?????????? ???????????????????????????????????????????? ??????????????????? * * ??????????????????????????????????????????????????????????????????????????????????????????????????????? ?????? * * * * ????????????????????????????? * * * * ??????????????????????????????????? * * * * * ?????????? ???????????????????????? * * * * * * ???????????????????? ????????????? * * * * * * * ????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ? * * * * * * * * * ??????????????????????? * * * * * * * * * * ?????????????????????????????? * * * * * * * * * * ?????????? ??????????????????? * * * * * * * * * * * ??????????????????????????? ??????? * * * * * * * * * * * * * ??????????????????? * * * * * * * * * * * * ?????????????????????????? * * * * * * * * * * * * * * * ?????????????????????????? * * * * * * * * * * * * * * * * ?????????? ?????????????? * * * * * * * * * * * * * * * * * ???????????????????????????????????????????????????????????????????????????? ?? * * * * * * * * * * * * * * * * * ?????????????????????? * * * * * * * * * * * * * * * * * ????????????????????? * * * * * * * * * * * * * * * * * * * * * ???????????????????? * * * * * * * * * * * * * * * * * * * * ????? ?????????????? * * * * * * * * * * * * * * * * * * * * * ??????????????? ?? * * * * * * * * * * * * * * * * * * * * * * ???????????????? * * * * * * * * * * * * * * * * * * * * * * * ???????????????? * * * * * * * * * * * * * * * * * * * * * * * * ??????????????? * * * * * * * * * * * * * * * * * * * * * * * * * ????? ???????? * * * * * * * * * * * * * * * * * * * * * * * * * * * ???????????? * * * * * * * * * * * * * * * * * * * * * * * * * * * ??????????? * * * * * * * * * * * * * * * * * * * * * * * * * * ?????????? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ????????? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ??????? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ?????? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ????? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ???? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ??? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ?? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ????????????????????????????? * * * ?????????????????????????????? * * * ???????? ??????????????????????????????????????????? ???????????????????? * * * ??????????????????? ????????? * * * sql> set heading onsql> set feedback onsql>

?

?

A small cypress

http://blog.9cbs.net/lunar2000/Archive/2004/07/26/51718.aspx

sys @ TEST_LUNAR> set heading onsys @ TEST_LUNAR> set feedback onsys @ TEST_LUNAR> sys @ TEST_LUNAR> set heading offsys @ TEST_LUNAR> set feedback offsys @ TEST_LUNAR> set pagesize 2000sys @ TEST_LUNAR> sys @ TEST_LUNAR> select decode? 2 ???? ???? (sloor (Maxwidth / 2) -rownum)? 3 ?????????, 1, lpad ('', floor (maxwidth / 2) - (ROWNUM-1))? 4? ?????????? || RPAD (CHR (257), 2 * (ROWNUM-1) 1, '' || CHR (257))? 5 ?????????, LPAD ( CHR (257) || CHR (257) || CHR (257), FLOOR (MAXWIDTH / 2) 3))? 6? from all_Objects? 7 ????, (SELECT 25 AS MAXWIDTH from DUAL)? 8? WHERE ROWNUM

???????????? ?????????? ??????????????????? ? ????? ????????????????????????? ?????? ???????? ??????? sys @ Test_lunar> SES @ Test_lunar> Set Heading Onsys @ Test_lunar> Set Feedback Onsys @ Test_lunar> Sys @ Test_lunar>?

Red bean iceberg

http://blog.9cbs.net/lunar2000/Archive/2004/07/26/51720.aspx

sys @ TEST_LUNAR> set heading onsys @ TEST_LUNAR> set feedback onsys @ TEST_LUNAR> set heading offsys @ TEST_LUNAR> set feedback offsys @ TEST_LUNAR> set pagesize 2000sys @ TEST_LUNAR> sys @ TEST_LUNAR> select decode? 2 ???????? (Sign (floor (MAXWIDTH / 2) -ROWNUM)? 3 ?????????, 1, lpad ('', floor (maxwidth / 2) - (ROWNUM-1))? 4 ????? ????? || rPAD ('*', 2 * (rownum-1) 1, '*')? 5 ????????)? 6? from all_Objects? 7 ????, (SELECT 10 AS MAXWIDTH from DUAL)? 8? WHERE ROWNUM

???? * ??? * * ?? * * *? * * * *

Sys @ Test_lunar> SYS @ Test_lunar> Set Heading Onsys @ Test_lunar> Set Feedback Onsys @ Test_lunar>

?

?

Thankful

http://blog.9cbs.net/lunar2000/Archive/2004/07/26/51724.aspx

Set Heading Offset Feedback Offset PageSize 2000

SELECT TFROM (SELECT T, ROWNUM ROWCOUNT from T) Torder by RowCount DESC;

Set Heading Onset Feedback on

SQL> SELECT T? 2? From (SELECT T, ROWNUM ROWCOUNT FROM T) T? 3? Order by RowCount DESC;

T --------------------------------------------------- ----------------------------- ??? ((`'-" `` "" -' `)? ???) ?? - ??? -? (??? / ?? (o _ o) ?? / ??? / ??? (0) ??? / ??? _'-.._ '=' _..-'_? /`;#'#'#.-.#'#'#;`/? / _) ??? '#' ??? ((_ /??? #.? ☆ ☆ ☆ ?? # ??? '#.? Thank you! #' ??? / '#. ?????. #' / ?? _ /? / '#. #' /? / _? ((___) '#' (___) 12 Rows Selectted

SQL>

?

?

转载请注明原文地址:https://www.9cbs.com/read-13276.html

New Post(0)