what is the meaning of [ *= ] in T-SQL and [ (+) ] in PL/SQL ?
644653Aug 13 2008 — edited Aug 14 2008Hi,
There is a T-SQL:
/////
declare @v_sql varchar(5000)
set @v_sql = 'select * from dt1 t1, dt2 t2 where t1.date *= t2.date'
exec(@v_sql)
/////
This statement is from a stored procedure and it works till now. But I cannot find the meaning of ( *= ). When I use Sql Developer Translation Scratch Editor to translate only the T SQL in string form, it becomes:
/////
SELECT * FROM dt1 t1, dt2 t2 WHERE t1.date = t2.date(+);
/////
what is the [ *= ] in TSQL and [ (+) ] in PL/SQL ? Is it the [ * ] have special meaning before [ = ] when in Single Quotation string form? Just like [ ' ] before [ ' ]. Thanks.