Hi All,
I'm new to PL/SQL and I'm using SQL developer 4.1. I'm using SQL developer to convert from SQL sysntax to PL/SQL syntax from "Tools-->Migration-->Scratch Editor", the SQL query that I'm trying to convert to PL/SQL contains "OPENROWSET", the SQL developer gave me the following converted query in PL/SQL syntax:
INSERT
INTO aradmin.tbl_Huawei_Cells
( SELECT * FROM TABLE(/*TODO:SQLDEV*/
OPENROWSET ('MSDASQL','fmdb';
'AutoCfg';
'CfgPwdAc','select charindex("Cell Name=", ExtendInfo),substring(ExtendInfo,charindex("Cell Name", ExtendInfo)+10,charindex(",",substring(ExtendInfo,charindex("Cell Name", ExtendInfo)+10,100))-1) from tbl_alm_log_2000000000 where Id=21802 AND ExtendInfo like "%Block Type=LOCK%"')
/*END:SQLDEV*/
)
);
when I'm trying to run the above query on SQL developer, it gives "Unkown command" error. Any ideas regarding using "OPENROWSET" in Oracle? or if there is equivalent command to OPENROWSET in oracle? or the "Unkown command" error has another cause?
please advise for that and thanks in advance.
Regards,
Mona Fathy