Both MS Teams and Slack allows searching through all chat sessions, putting an end to the nightmare of trying to find one comment among thousands. If you’ve opted for the free version of Slack, however, the search function only applies to the 10,000 most recent messages.
Microsoft’s WhoBot tool helps with search in MS Teams. This search bot crawls your entire company intranet to surface the data you’re looking for. It also helps you access subject matter experts within your organization so you can find the best person for what you’re looking for.
LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another, the
LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second.
The following query finds the salaries of all employees with the name ‘SM%’. Oracle interprets ‘SM%’ as a text literal, rather than as a pattern, because it precedes the
WHERE 'SM%' LIKE last_name;
There are no
ILIKEcondition in Oracle SQL, but you still can have alternative way to do it.
Using Case Sensitivity (alternative to
Case is significant in all conditions comparing character expressions that the
LIKE condition and the equality (=) operators. You can use the
UPPER function to perform a case-insensitive match, as in this condition:
UPPER(last_name) LIKE 'SM%'
pbcopy on a mac enables you to copy the standard input from terminal window to your clipboard enabling you to paste it to other applications.
You can replicate
pbcopy on ubuntu by utilising a similar tool called
xclip which does exactly the same. However its syntax is a little too verbose and I prefer to use OS X
If you haven’t previously installed xclip simply run the following command in your terminal window:
sudo apt-get install xclip -y
Edit your BASH settings file using your favorite text editor.
Then create an alias for pbcopy and pbpaste:
alias pbcopy=’xclip -selection clipboard’
alias pbpaste=’xclip -selection clipboard -o’
Close and save the file then just refresh your bash to import your new settings
pbcopy < /etc/resolv.conf