dungsaga

To research a topic xyz, I often search it with some keywords to know how people feel about it.

love it

• xyz great
• xyz love
• xyz like
• xyz favorite
• xyz fun

dungsaga

Hex words with only letters (a to f) in English from https://www.dictionary.com/:

• a
• aa (basaltic lava having a rough surface)
• be
• ea (the Akkadian god of wisdom, the son of Apsu and father of Marduk: the counterpart of Enki)
• fa (the syllable used for the fourth tone of a diatonic scale)
• aba (a coarse, felted fabric woven of camel's or goat's hair)
• abb (low-grade wool from the breech or outer edges of a fleece)
• ace
• ate

dungsaga

check for errors

git fsck --full

error: HEAD: invalid reflog entry 9fa7d8a22a680f8cf76e560ddb9e910419936006
error: refs/heads/local-api: invalid reflog entry c26cc0ae14632bd6a6d09aeb8973f97ccfc3035c
error: object file .git/objects/6b/f03a2e38b9cf909eff2500c14fce48a61d2965 is empty
error: object file .git/objects/6b/f03a2e38b9cf909eff2500c14fce48a61d2965 is empty
fatal: loose object 6bf03a2e38b9cf909eff2500c14fce48a61d2965 (stored in .git/objects/6b/f03a2e38b9cf909eff2500c14fce48a61d2965) is corrupt

dungsaga

学习网站

www.symbo1.com

https://github.com/phith0n

https://www.leavesongs.com/

Webshells

https://www.webshell.cc/

dungsaga

reference: https://www.postgresql.org/message-id/[email protected]

Since the view definition is installed by initdb, merely upgrading will
not fix the problem. If you need to fix this in an existing installation,
you can (as a superuser) drop the information_schema schema then re-create
it by sourcing SHAREDIR/information_schema.sql. (Run pg_config --sharedir
if you're uncertain where SHAREDIR is.) This must be repeated in each
database to be fixed.

dungsaga

install Oracle XE 18x under WSL2

• install package is RPM, it's easier to use CentOS 7 or 8 (from CentOS-WSL or wsldl)
• if you want to use Debian/Ubuntu, you must convert RPM to DEB (but conversion with alien fails under Debian)
• first, install oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
• second, install oracle-database-xe-18c-1.0-1.x86_64.rpm
• see https://mikesmithers.wordpress.com/2019/01/03/installing-and-configuring-oracle-18cxe-on-centos/
• run as root: /etc/init.d/oracle-xe-18c configure
• it would fail if host IP is auto-generated to be 127.0.1.1
• you can update the IP in /etc /hosts and try it again

dungsaga

install Oracle XE 18c under WSL2

• install package is RPM, it's easier to use CentOS 7 or 8 (from CentOS-WSL or wsldl)
• if you want to use Debian/Ubuntu, you must convert RPM to DEB (but conversion with alien fails under Debian)
• first, install oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
• second, install oracle-database-xe-18c-1.0-1.x86_64.rpm
• see https://mikesmithers.wordpress.com/2019/01/03/installing-and-configuring-oracle-18cxe-on-centos/
• run as root: /etc/init.d/oracle-xe-18c configure
• it would fail if host IP is auto-generated to be 127.0.1.1
• you can update the IP in /etc/hosts and try it again

dungsaga

ref: https://stackoverflow.com/questions/39576/best-way-to-do-multi-row-insert-in-oracle

INSERT ALL
   INTO t (col1, col2, col3) VALUES ('val1_1', 'val1_2', 'val1_3')
   INTO t (col1, col2, col3) VALUES ('val2_1', 'val2_2', 'val2_3')
   INTO t (col1, col2, col3) VALUES ('val3_1', 'val3_2', 'val3_3')
   .
   .
   .

dungsaga

It's quite common to write SQL queries in a vertical horizon code style. For example:

INSERT INTO table (
    column1,
    column2,
    column3,
    column4,
 column5,

dungsaga

Reduce size with diskpart

You should run PowerShell as Administrator (otherwise diskpart won't be able to received the piped commands)

$vhdx_path = '%USERPROFILE%\AppData\Local\Packages\CanonicalGroupLimited.UbuntuonWindows_79rhkp1fndgsc\LocalState\ext4.vhdx'

@"
select vdisk file=$vhdx_path
compact vdisk