Differences beween DDL (Data Definition Language) and DML (Data Manipulation Language)
Data Definition Language (DDL) statements are used to define the database structure or schema.
Data Manipulation Language (DML) statements are used for managing data within schema objects.
References:
http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands
MediaWiki’s Sidebar can be configured as a special page. This page’s title is “MediaWiki:Sidebar”. For example, if a MediaWiki site www.example.com is configured to use [[search-engine-friendly-url-for-mediawiki]], the URL for edit the Sidebar is: http://www.example.com/w/MediaWiki:Sidebar It may look like this: * navigation ** mainpage|mainpage-description ** recentchanges-url|recentchanges ** randompage-url|randompage ** currentevents-url|currentevents ** portal-url|portal ** helppage|help * SEARCH…
In Python, how to get hostname as the command hostname does on Linux? In Python, you can get the hostname by the socket.gethostname() library function in the socket module: import socket hostname = socket.gethostname() Reference: https://www.systutorials.com/dtivl/20/how-to-get-the-hostname-of-the-node?show=34#a34 Read more: How to get the hostname of the node in Python? Getting Hostname in Bash in Linux in…
How to install Dropbox on Linux ? Just follow Dropbox’s instruction here: https://www.dropbox.com/install?os=lnx A quick command for 64-bit Linux: $ cd ~ && wget -O – “https://www.dropbox.com/download?plat=lnx.x86_64” | tar xzf – Use the dropx CLI: http://www.dropboxwiki.com/Using_Dropbox_CLI Download dropbox.py: $ wget -O ~/bin/dropbox.py “https://www.dropbox.com/download?dl=packages/dropbox.py” Set the permissions: $ chmod +x ~/bin/dropbox.py Start Dropbox: $ dropbox.py start Status:…
Tutorials on how to create patches and apply patches with git. A nice tutorial: https://ariejan.net/2009/10/26/how-to-create-and-apply-a-patch-with-git/ Manuals: git format-patch: https://www.systutorials.com/docs/linux/man/1-git-format-patch/git apply: https://www.systutorials.com/docs/linux/man/1-git-apply/ Read more: How to create a git branch on remote git server How to do diff like `git diff –word-diff` without git on Linux? Cheatsheet: Git Branching with a Git Server What about the…
How to transfer text messages from android phone to computer? One solution is to use the SMS Backup & Restore app. The app will backup your messages to a microSD card and then you can copy it out to a PC by connecting your Android phone to your PC with the USB cable. Read more:…
By default, Vim does case sensitive search. How to make case-insensitive search in Vim? By default, Vim does case sensitive search. :set ignorecase can set Vim to conduct case insensitive search. However, it also affects substitutions, which is not we want However, how to do a case insensitive search only when it is needed? Use…