Summary of Common commands for executing scripts in Oracle databases and common commands in oracle
1. Execute an SQL script file
Copy codeThe Code is as follows:Sqlplus user/pass @ servicename
Or
Copy codeThe Code is as follows:SQL> start file_names
Or
Copy codeThe Code is as follows:SQL> @ file_name
We can save multi
Summary of Common commands used to execute scripts in oracle databases and common commands used in oracle
1. Execute an SQL script file
The Code is as follows:Sqlplus user/pass @ servicename OrSQL> start file_namesOrSQL> @ file_name
We can save multiple SQL statements in a text file, so that when we want to execute all
administrator-M: Specifies that the group member and-a use almost-R: Remove password-r: Restrict user login group, only members in group can join the group with NEWGRPGpasswdgroupname : If the system has a Peter account, the account itself is not a member of the GroupName group, use NEWGRP need to enter a passwordLet the user temporarily join the group, and then the file group created by Peter will be groupname. So this way you can temporarily let Peter build the textUse other groups instead of
Unzip file-Z DecompressionExample: TAR-ZXVF Japan.tar.gz11. Compress files or directories: Zip, compressed after file name *.zipZip option [-r] [filename after compression] [file or directory]-R: Compressed directory12. Unzip the. zip file: UnzipUnzip [compressed file]13. Compressed files: bzip2, compressed after file name *.bz2BZIP2 option [-K] [file]-K preserves source files after generating compressed files14. Unzip:bunzip2BUNZIP2 option [-K] [compressed file]-K retain original file after de
Ten commands required for Linux commands and ten commands for linux
Linux has now become the most popular Operating System in the software industry. Mastering Linux has become a requir
Help commands for common linux commands and common linux commands
1.TypeThe difference between built-in and external commands
2.BashEnter bash to use help in bash.
3.Help lsLs is an external command, help can only view the bui
Linux notes (6) Help commands and user management commands for common Linux commands(1) man
The man command is used to obtain help information of a command or configuration file. The original English meaning is manual, and the path is/usr/bin/man. Its Syntax format is:
Man [
Linux learning notes (5) file search commands for common Linux commands and Common commands for learning notes(1) find
The find command is used for file search. Its path is/bin/find. Its Syntax format is:
Find [search range] [matching condition]
1)-name: search by file name,
Help for Umask:[Email protected] ~]# help Umaskumask:umask [-P] [-S] [mode] file mode mask.Note:help can also be used to view assistance for Shell programming if, case, while, and so on .(6) UseraddThe useradd command is used to add a new user , where the path is/usr/sbin/useradd, with the syntax format:useradd [user Name](7) passwdThe passwd command is used to set the user password , where the path is/USR/BIN/PASSWD, in the syntax format:passwd [user Name]Note: Passwords must conform to th
Notes on common Oracle commands and common oracle commands
Login without a password: sys as sysdba
View all current databases: select */name from v $ database;
View the current database connection user: show user
View All Tables of the current data: select table_name from all_tables;
View Structure: for ex
control, cross-operating systems, data interoperability across hardware platforms, support for multi-user, transaction handling of event volumes, and portability.-Oracle 11g Installation tutorials are not detailed, see https://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.html Web page-Oracle 11g Uninstall: First find the directory App\administrator\product\11.2.0\dbhome_1\deinstall, Click Deinstall.b
In Linux, how does one view, kill, and start processes? (Common commands), common linux commands
Keywords: linux Process query, killing process, Starting Process
1. Check the process
Ps command to find the process-related PID:
Ps a shows all programs under the current termin
One, the Linux CPU sizeCat/proc/cpuinfo |grep "model name" cat/proc/cpuinfo |grep "Physical ID"Description: Detailed information about each CPU can be seen in/proc/cpuinfo under Linux. But for a dual-core CPU, you will see two CPUs in the Cpuinfo. It is often mistaken for a two single-core CPU.You should actually differentiate between single-core and dual-core by physical Processor ID. The physical Process
Linux commands-linux File and permission management commands-linux permission management
1. ubuntu tips:
In ubuntu, you can press ctrl + alt + t to open the terminal, and press ctrl + shift + t to open the second terminal.
Adjust the font in ubuntu terminal
Font increase: ct
(1) linux beginners: linux concepts and Common commands, common linux commandsLinux introduction:
Linux is a free, free, and open source operating system. It is also the most famous example of open-source software. Its main purpose is to establish a Unix-like compatible prod
Detailed explanation of ln commands in linux commands (creating soft links and hard links) and ln commands
Ln is another important command in linux. Its function is to create a synchronous link for a file in another location, which can be soft link or hard link. Soft links a
Common commands for linux learning records and commands for linux recording1. enable or disable the server (effective immediately): service iptasbles startservice iptasbles stop2. when the firewall is enabled, make the following settings to enable the relevant ports,Modify the/etc/sysconfig/iptables file and add the fo
Learn about basic Linux commands: df commands and du commands-general Linux technology-Linux technology and application information. For more information, see the following. Df command
This interface is used to view the status in
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.