|
All in One -
Data
|
|
Written by Administrator
|
|
Monday, 15 February 2010 15:42 |
Cause When you use merge statement Action You have to check primary key constraint for two tables in merge statement. |
|
All in One -
Data
|
|
Written by Administrator
|
|
Wednesday, 18 November 2009 23:29 |
|
=IF(ISNA(VLOOKUP(J7;$M$7:$M$1682;1;FALSE));"0";"1") |
|
All in One -
Data
|
|
Written by Administrator
|
|
Tuesday, 15 September 2009 07:22 |
|
in procedure or pl-sql block you have to add commit or rollback |
|
All in One -
Data
|
|
Written by Administrator
|
|
Friday, 14 August 2009 07:19 |
|
Use Exists instead of IN dont use : 27 seconds select count(*) from pro where pro_id in ( select pro_id from sales) OK : 20 seconds
select count(*) from pro p where exists ( select 1 from sales s where s.pro_id=c.pro_id * index should be created in different tablespace with table |
|
Last Updated ( Tuesday, 25 August 2009 06:43 )
|