You are currently browsing the Database Management and Programing Article weblog archives for October, 2007.
You are currently browsing the Database Management and Programing Article weblog archives for October, 2007.
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..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..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..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..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..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..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..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..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..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..