oracle database 11g sql fundamentals

SQL: Oracle 11g create table, function, trigger, sequence, 11 gtrigger -- Place directory drop table BookPlaceList; create table BookPlaceList (BookPlaceID int primary key, -- NUMBERBookPlaceName nvarchar2 (500) not null, BookPlaceCode varchar (100) null, -- location parameter BookPlaceParent INT null -- BookPlaceKindId nvarchar (500) null -- place DIRECTORY para

Replace (char, str1, str2)Replaces every occurrence of str1 in char with str2. Length (char)Returns the length of the char. Initcap (char)Changes the first character of each element in Char to uppercase. Power (m, n)Multiplies m to the power N. SQRT (N)Returns the square root of N. Current_timestampReturns the current timestamp along with the time zone offset. YearYear spelled out. For example:Select to_char (sysdate, 'Year') from dual ;------- Twenty eleven WWWeek of year. For example:Select to

Sort after adding nulls last in descending order, put null in the finalSelect To_char (sysdate, ' Q ') from dual;Dual pseudo-table public synonym because it has a record for easy readingSelect RowNum, ' A ' | | Rownum,mod (rownum,2) from dual connect by rownumSelect Rownum,to_date (' 2016-05-01 ', ' YYYY-MM-DD ') from dual connect by rownumSelect sysdate,sysdate+1/24,sysdate+1/1440 from dual;Select To_char (sysdate, ' Fmyyyy-mm-dd h24:mi:ss ') from dual;Select 100+NVL (null,0) from dual;Select c

syntaxes: case when field name = ... then ... (infinite access) else ... end Case field name when ... then ... (infinite access) else ... end Don't write End is a pig, forget n+1 times Decode () function The decode () function is somewhat similar to the use of Case...when Decode (field name, ' Value 1 ', ' corresponding value of value 1 ', ' Value 2 ', ' value 2 corresponding value ' ... (Infinite Connection) ..., ' Default ') Vm_concat () function Select Sname,student.sno,wm_concat (CNO) fro

access/etc/x11/xinit/xinitrc:no such file or Directory[[emailprote CTED] ~]# Find/-name xinitrc[[emailprotected] ~]# adopted the scheme is to comment out/root/.vnc/xstartup inside the EXEC/ETC/X11/XINIT/XINITRC , let Vncserver choose the default, let VNC load the default graphical interface program It's OK.--------------------------------------------------------------------change the permissions of Xstartup This is a problem that many people tend to overlook, is also the cause of the black scre

This article introduces some common statements used to import and export tablespaces in oracle 11g linux. For more information, see. Sqlplus /As sysdba -- View the dbf storage locationSelect * from dba_data_files; -- view the file location SELECT * FROM dba_directories;-- Create a tablespaceCreate tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf' size 100 m autoextend on next 50 m max

DbconsoleEmca-repos CreateEmca-config Dbcontrol DBEmctl Start DbconsoleSteps to reconfigure DbconsoleEmca-repos DropEmca-repos CreateEmca-config Dbcontrol DBEmctl Start DbconsoleCheck Status: Emctl status DbconsoleC:\Documents and Settings\administrator>emctl status DbconsoleOc4j Configuration issue. D:\app\administrator\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBCONSOLE_LOCALHOST_ORCL not found.Late:Emctl Status Dbconsoleenvironment variable oracle_unqname not defined. Please set Oracle_unqname

15th and a day of 0:00 execution42 4 1 * * Every month 1st 4:42 minutes execution0 21 * 1-6 weeks one to Saturday 21:00 execution0,10,20,30,40,50 * * * * * every 10 minutes*/10 * * * * * every 10 minutes* 1 * * * * Every 1 minutes from 1:0 to 1:590 1 * * * 1:00 execution0 */1 * * * 0 minutes every 1 hours0 * * * * 0 minutes every 1 hours2 8-20/3 * * * 8:02,11:02,14:02,17:02,20:02 execution30 5 1,15 * * 1st and 15th of 5:30 execution Backup results: Automatic Backup is set to 2:30 every

defineCollectionType. Created at the Mode LevelCollectionType isStandalone stored type. UseCREATE TYPEStatement creation. It is stored in the database until it is usedDROP TYPEStatement to delete this type. Created in the packageCollectionType isPackaged type. It is stored in the database until it is usedDROP PACKAGEStatement to delete a package. Created in the PL/SQL