CPP_CHEN的专栏

Tables:Table name Descriptionall_views all_tables all_objects all_object_tables all_ind_columns all_indexes dba_ind_columns

1)  Query recent executed SQL for user from V$SQLSQL>col sql_text format a50 truncateSQL>select /* recentsql */ sql_id, child_number, hash_value, address, executions, sql_text  2  from v$sql

1) Dump all console screen to a fileSQL>spool c:\log.txtSQL>execute sql ...SQL>spool off2) Modify the line size, page size to let the report more neat.SQL>set line 150SQL>set pagesize 999

SQL> desc dba_ind_columns Name                                                              Null?    Type ----------------------------------------------------------------- -------- ---------------

While create connection to Oracle XE database, CrystalReport 2010 reports "JDBC driver not found". Here is the solution to fix this prolem.1) copy "ojdbc6.jar" Oracle JDBC Driver to "C:\Program File

String Aggregation TechniquesOn occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. Using the SCOTT.EMP table

Select from v$session and v$processselect       substr(a.spid,1,9) pid,       substr(b.sid,1,5) sid,       substr(b.serial#,1,5) ser#,       substr(b.machine,1,6) machine,       substr(b

From the internet:1) Delete duplicatesdelete from twhere rowid in (                  select rid                 from ( select rowid rid, row_number() over (partition by cust_seg_nbr or

Problem:SQL> drop user ecrpuser cascade;drop user ecrpuser cascade*ERROR at line 1:ORA-01940: cannot drop a user that is currently connectedSolution:select sid||','||serial# from v$ses

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6618304976523ops$tkyte@ORA920.US.ORACLE.COM> create global temporary table ao 2 on commit PRESERVE ROWS 3 as 4 select *

SQL> create directory log_test as 'c:\ken\sql\learning';Directory created.SQL> grant read,write on directory log_test to public;Grant succeeded.FileLogTest.sql=================

1) Sub-optimal index. SQL> -- Example 1: sub-optimal indexSQL>SQL> select /* KM1 */ job_id, department_id, last_name2 from employees3 where job_id = 'SA_REP'4 and department_id is null ;

MyEclipse 8.6.1, Oracle 11.1g standard edition, jdk1.6.0_31 are already installed.1)  Locate the JDBC driver provided by ORACLE under [ORACLE_HOME]\jdbc\lib\ojdbc6.jar or download the drivers from o

Ask TomTom KyteJL Computer ConsultancyJonathan LewisMethod-RCary MillsapIxOraSteve AdamsEvergreen Database TechnologiesTim Gorman

SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';SQL> SQL STATEMENT GOES HERESQL> ALTER SESSION SET EVENTS '10046 trace name context off';Tips:1) Query the generat

This is a summary of the solution for issue "ORA-01654: unable to extend index ..." from internet.1) Check table space usage.SELECT UPPER(F.TABLESPACE_NAME) "TblSpName",D.TOT_GROOTTE_MB "Tbl

I wrote a SQL script as below, while executing it, encountered 'PLS-00103: Encountered the symbol "CREATE"' error.logging.sql----DROP SEQUENCE pt_debug_sequence;CREATE SEQUENCE pt_debug_sequ

SQL> help helpEnter Help [topic] for help. @                COPY         PAUSE                    SHUTDOWN @@            DEFINE       PRINT                    SPOOL /

C:\Users\chenk6>sqlplus -H...-S            Sets silent mode which suppresses the display of                the SQL*Plus banner, prompts, and echoing of                commands....C:\

Please help me in resolving the error belowCode:=====DECLARE --count NUMBER;tname NVARCHAR2(255);indexname NVARCHAR2(255);tablename NVARCHAR2(255);--tname:= 'TABLE_PART_ACTION';

1) The table/sequence in the procedure does not exist which cause "Statement is ignored ..."SQL>@Logging.sqlLINE/COL ERROR-------- ---------------------------------------------------------

DDL(Data Definition Language):(DDL) statements are used to define the database structure or schema. Some examples:[*]CREATE - to create objects in the database [*]ALTER - alters the structure

If the prereuisite CV_ASSUME_DISTID=OEL4 to CV_ASSUME_DISTID=OEL6