Bert Gombos
Member²
If a table exists with the same name as table alias, table name is used instead of table alias. I recommend to change priority.
code assistant with table name alias
- Thread starter Bert Gombos
- Start date
This seems to work correctly for me:
I get a list of emp columns at this point.
Can you provide an example where it fails?
Code:
select * from emp dept
where dept.I get a list of emp columns at this point.
Can you provide an example where it fails?
Bert Gombos
Member²
update ht_wcs2_pol t
set t.result = '8'
where t.result = '3'
and exists (
select 1
from ht_wcs2_pol_res2 t2,
ocp_policy_versions t3
where t2.contract_id = t.contract_id
and t2.contract_id = t3.contract_id
and t2.version_no = t3.version_no
and t3.business_start_date >= t.change_date
);
There is another table named "t2".
If you expand select list with ", t2." or where clause with "and t2.", code assistant show columns of table t2.
set t.result = '8'
where t.result = '3'
and exists (
select 1
from ht_wcs2_pol_res2 t2,
ocp_policy_versions t3
where t2.contract_id = t.contract_id
and t2.contract_id = t3.contract_id
and t2.version_no = t3.version_no
and t3.business_start_date >= t.change_date
);
There is another table named "t2".
If you expand select list with ", t2." or where clause with "and t2.", code assistant show columns of table t2.
Bert Gombos
Member²
update ht_tcs_pol_curr t
set t.distribute = 1
where t.distribute = 0
and exists (
select 1
from ht_tcs_area_agent t3
where t3.
);
After "where t3." code assistant can't revolve alias "t3", this is the reason for previous problem.
set t.distribute = 1
where t.distribute = 0
and exists (
select 1
from ht_tcs_area_agent t3
where t3.
);
After "where t3." code assistant can't revolve alias "t3", this is the reason for previous problem.
Can you verify this with the current 8.0.1.1501 hotfix? It has been released yesterday, but is not yet published through the online update system.
Bert Gombos
Member²
OK, it works. Thanks!
It's available on our web site.
You can simply download the PL/SQL Developer file. You don't need to register.
Similar threads
- Discussion
