oracle dba fundamentals

"/" representation.We'll just remember a few catalogs for the time being.A "/" root directory, all other directories derived from here, a system on a "/"A/boot directory, this directory is mounted under the root directory "/", storage is the boot fileA/home directory where all new users are likely to have working directories in that directory, yes, it is possible, because some may not or need not.3.5 Other common commands#ssh Secure Shell protocol for remote login#ftp File Transfer ProtocolStan

Label:stylecolorsponbs adefsqloracle concat (' Hello ', ' world ') stitching HelloWorld substr (' HelloWorld ', 1,5) intercept Hello Length (' HelloWorld ') string length ten InStr (' HelloWorld ', ' W ') W characters first occurrence 6 Lpad (1200,6, ' * ') If 1200 complements 6 bits, fill ' * ' **1200 on the left of 1200 rpad (1200,6, ' * ') If

95031 107Wang Liju1976/1/ at 95033 101Li June Man1976/2/ - 95033 109Wang Fang Men1975/2/Ten 95031 103Contacts male1974/6/3 95031 6rows selected SQL> SetServeroutput on; SQL> ExecuteHanqi (95031); Kuanming Wang Fang contacts PL/SqlprocedureSuccessfully completed v. Functions (function) Functions are constructed in a similar way to stored procedures CREATE OR REPLACE FUNCTION inch Number inch Number RETURN Number as number ; BEGIN C:=+ B; RETUR