DBA Data[Home] [Help]

SYS.STANDARD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 73

      select soundex(ch) into c from sys.dual;
Line: 173

        select uid into i from sys.dual;
Line: 180

        select user into c from sys.dual;
Line: 208

          select userenv('TERMINAL') into c from sys.dual;
Line: 215

          select userenv('ENTRYID') into c from sys.dual;
Line: 222

          select userenv('SESSIONID') into c from sys.dual;
Line: 229

          select userenv('LANGUAGE') into c from sys.dual;
Line: 236

          select userenv('LANG') into c from sys.dual;
Line: 243

          select userenv('INSTANCE') into c from sys.dual;
Line: 250

          select userenv('CLIENT_INFO') into c from sys.dual;
Line: 257

          select userenv('ISDBA') into c from sys.dual;
Line: 264

          select userenv('SCHEMAID') into c from sys.dual;
Line: 271

          select userenv('SID') into c from sys.dual;
Line: 278

          select userenv('PID') into c from sys.dual;
Line: 339

   select nls_charset_name(csetid) into v from sys.dual;
Line: 347

   select nls_charset_id(csetname) into i from sys.dual;
Line: 355

   select nls_charset_decl_len(bytecnt, csetid) into i from sys.dual;
Line: 546

      select sysdate into d from sys.dual;
Line: 560

        select sys_guid() into c from sys.dual;
Line: 578

      select sys_context(namespace,attribute) into c from sys.dual;
Line: 597

      SELECT systimestamp INTO t FROM sys.dual;
Line: 614

      SELECT dbtimezone INTO t FROM sys.dual;
Line: 646

      select sys_context(namespace,attribute,newoptional) into c from sys.dual;