Posts tagged with “tips”

Power shell: Start-Transcript and Stop-Transcript help you log a session.

Linux： How do I keep my laptop running when the lid is closed?

In short,

sudo vim /etc/systemd/logind.conf

Find and uncomment the following lines, and change the values

HandleLidSwitch=lock
HandleLidSwitchExternalPower=lock
HandleLidSwitchDocked=ignore

Save and exit, and 

sudo systemctl restart systemd-logind

Fix Albert core dumping after the first request After the system upgrades

Steps:

rm ~/.config/albert/core.db

Reference

JetBrains Rider/Intellij... Disabling database schema/table names being prepended with autocomplete

Preferences/Settings

Editor > General > Code Completion > SQL > Qualify object with > Table > Never.

Reference

Keep the the same order as input data when using `WHERE fieldName IN(fieldVal1, fieldVal2)`

Don't waste time; here's the sample code with the Oracle database.

SELECT * FROM SampleTable WHERE sample_field in (7,3,4,6) ORDER BY INSTR(',7,3,4,6,',  ',' || sample_field || ',');