Declare sql server 转oracle语句

Declare @sql varchar(8000)
Set @sql = 'select '
Select @sql = @sql + Subject+','
from (select distinct Subject from cj) as cj 
Set @sql=SubString(@sql,1,len(@sql)-1)
Select @sql = @sql+' from table3'
Exec (@sql)