oracle system function sys_context

2010-11-18  来源:本站原创  分类:Database  人气:83 

sys_context

  • terminal: the customer the current session identifier corresponding to the terminal
  • language: Language
  • db_name: name of current database
  • nls_date_format: the current session date format corresponding to the customer
  • session_user: corresponding to the current session client database user name
  • current_schema: current session client program corresponding to the default name?
  • host: returns the name of the database hosts
  • Function had been changed, you can check some important information, such as which database you are using

select sys_context ('userenv',, 'db_name') from dual; ------ red as the default without modification

相关文章
  • oracle system function sys_context 2010-11-18

    sys_context terminal: the customer the current session identifier corresponding to the terminal language: Language db_name: name of current database nls_date_format: the current session date format corresponding to the customer session_user: correspo

  • ORACLE system function Daquan SQLSERVER similarities and differences between the system functions (transfer) 2011-06-29

    The following are Oracle functions supported by the characters and their Microsoft SQL Server equivalent functions. Character Functions The following are Oracle functions supported by the characters and their equivalent Microsoft SQL Server functions

  • ORACLE system function 2010-03-26

    1.EMPTY_BLOB () and EMPTY_CLOB () These two functions are used to initialize large data type field operations function 2.GREATEST Return a maximum of expression, that is more the size of character encoding. SQL> select greatest ('AA', 'AB', 'AC') fro

  • Oracle system are summarized 2010-03-21

    Use of the database is Oracle 10.2.0.1.0 Current mainstream databases including: Microsoft: SQLServer, Access Sweden MySQL: AB company MySQL IBM Corporation: DB2 IBM Corporation: Informix Sybase, the United States: Sybase American Oracle: Oracle Comp

  • ORACLE common function Demo 2010-08-18

    ORACLE common function Demo Documents written: Meng New EDITORIAL: ORACLE built-in function, the equivalent of C language library functions, a general database programming required in the most basic functions, and through a combination or nested func

  • oracle date function switch 2010-03-17

    oracle date functions Oracle date function Collection (1) A commonly used data format date 1.Y or YY or YYY last year, two or three SQL> Select to_char (sysdate, 'Y') from dual; TO_CHAR (SYSDATE, 'Y') -------------------- 7 SQL> Select to_char (sysd

  • Oracle plsql function Daquan 2010-04-13

    Oracle plsql function Daquan SQL in single-record function 1.ASCII Returns the character corresponding to the specified decimal number; SQL> select ascii ('A') A, ascii ('a') a, ascii ('0 ') zero, ascii (' ') space from dual; AA ZERO SPACE ---------

  • oracle system table Daquan 2010-08-27

    Transfer from http://daniel-wuz.javaeye.com/blog/145925 ORACLE System Tables treatment 1. Made all of the specified user name of the table: Java code SELECTOWNERAS "Object Owner", OBJECT_NAMEAS "table name", OBJECT_IDAS "object co

  • oracle system table used 2010-09-13

    dba_ beginning ..... dba_users database of user information dba_segments segment information table dba_extents data area information dba_objects database object information dba_tablespaces database table space information dba_data_files data file set

  • ORACLE system process table 2011-07-20

    This article comes from: http://shadamu.blogbus.com/logs/52351373.html 1. made ​​all the table name specified user: SELECT OWNER AS "Object Owner", OBJECT_NAME AS "Table Name", OBJECT_ID AS "Object Code" from dba_objects wher

  • Daquan Oracle system tables 2010-08-20

    Oracle system data dictionary table Daquan collection dict always part of the Oracle user sys. 1, the user: select username from dba_users; Change password alter user spgroup identified by spgtest; 2, table space: select * from dba_data_files; select

  • oracle ----- transfer function 2011-04-17

    Oracle The TO_DATE and TO_CHAR Function oracle TO_DATE function in the time format , With 2008-09-10 23:45:56 Example Format Display Remarks Year( Years ): yy two digits( Two years ) 08 yyy three digits( Three years ) 008 yyyy four digits( Four years

  • Oracle Date Function Highlights 2011-07-07

    Oracle date function Collection (a) A commonly used data format date 1.Y or YY or YYY was the last one, two or three SQL> Select TO_CHAR (SY SD ATE, 'Y') from Dual; TO_CHAR (SYSDATE, 'Y') -------------------- 7 SQL> Select to_char (sysdate, 'YY') fr

  • Oracle trunc () function 2011-07-08

    1.TRUNC (for dates) TRUNC function truncates the specified date and value elements. The specific syntax is as follows: TRUNC (date [, fmt]) Of which: a date value date fmt date format, the date specified by the format of the truncated element. Ignore

  • Oracle Database Function (single function) 2010-07-01

    Oracle Database Function (single function) Oracle's functions and C functions in almost the same also have the function names, parameter table, and return value types composed of single function, is the result for each record has a. One-way function

  • oracle substr function in the usage of 2010-08-31

    oracle substr function in the usage of In oracle / PLSQL, the substr functions allows you to extract a substring from a string. The syntax for the substr function is: substr (string, start_position, [length]) Description: string is the source string.

  • Oracle analytic function RANK (), ROW_NUMBER (), LAG () to use such 2010-10-15

    Oracle analytic function RANK (), ROW_NUMBER (), LAG () to use such ROW_NUMBER () OVER (PARTITION BY COL1 ORDER BY COL2) Said the group based on COL1, COL2 sorted according to the group within which the value is indicated after each sequence number w

  • oracle Round () function 2010-10-22

    oracle Round () function Round () function Return a value, the decimal value according to a specified number of bits for rounding the results of operations Syntax ROUND (number, decimal_places) number: the value to be rounded handle decimal_places: r

  • Oracle built-in function (greatest, least, to_single_byte) 2010-10-23

    Oracle built-in function (greatest, least, to_single_byte) Take a maximum of one-dimensional array greatest SELECT Greatest('a','x','fit','xa') FROM dual; Take a minimum of one-dimensional array least SELECT Least('a','x','fit','xa','ab') FROM dual;

  • Oracle System Structure - logical structure 2010-10-29

    One, Oracle Introduction to logical structure oracle logical structure, including the table space (tablespace), section (segment), the data block (data block) and the model object (schema). oracle database is logically composed of several tables, tab