Archive for October, 2007

Luxor 3

Wednesday, October 31st, 2007 Posted in ORACLE | 1 Comment »

Low Cost Game Luxor 3 $19.99Casual Pack:$10.00LUXOR 3 takes you on an ethereal journey where your Match-3 skills are used to battle the power-hungry god of Chaos. Stop the procession ... Read more..

Remove the table to repeat the combination of field records

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  When the design table when the field has not only built combination of constraints, the need to increase beyond this constraint, they found that table have a lot ... Read more..

Shared experience: techniques commonly used SQL statement

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  The following statement is part of Mssql statement, the access can not be used.    SQL Category:    DDL-data definition language (CREATE, ALTER, DROP, DECLARE)  ... Read more..

PL / SQL learning Notes (3)

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  - Information:    Syntax:    select col from table    where expr operator (select col from table);    Of the main query for the ... Read more..

ORACLE PERFORMANCE SQL TUNING

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  Recommend that users, then use the test himself, not to use the following methods and suggestions!    17. Table use the alias (Alias)    When the SQL ... Read more..

Consumption of resources to identify the most sql

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  select * from v $ process where spid ='2796 ';    select sql_hash_value, machine, username, program from v $ session where PAddr ='63B7A584 ';    select ... Read more..

Clone an Oracle Database

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

Description   Need to create a duplicate database on the same machine? Database too big to use Export / Import?    This is the easiest way to ... Read more..

Some commonly used by Oracle SQL

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  Table structure for    select substr (table_name, 1,20) tabname,    substr (column_name, 1,20) column_name,    rtrim (data_type )||'('|| data_length ||')' from system.dba_tab_columns    where ... Read more..

SQLServer data and the import export Excel table

Wednesday, October 31st, 2007 Posted in DATABASE BASIC | No Comments »

  Almost all the database managers or dealings with the database once a friend, almost all more or less understanding of import and export data used in support functions ... Read more..

MS SQL SERVER images or text input and output

Wednesday, October 31st, 2007 Posted in ORACLE | No Comments »

  MS SQL SERVER images or text input and output theme: MS SQL SERVER images or text input and output    MS SQL SERVER installed in the directory ... Read more..