I have a SQL statement that I wrote in 9i. I tried to run it in Visual studio and apparently the oracle data adapter that we are using only recognizes the 8i syntax. I wanted to know if anyone knew how to convert the following statement into its equivilent 9i counterpart...
SELECT DISTINCT CC.CABLE_NUMBER, CD.DRAWING_NUMBER
FROM (CMS_DUC.CABLE CC LEFT JOIN EIDB_DUC.CABLE EC
ON CC.CABLE_NUMBER = EC.CABLE_NO)
I INNER JOIN CMS_DUC.DRAWING CD
ON CC.MASTER_SCHEMATIC = CD.DRAWING_ID
WHERE EC.CABLE_NO Is Null
ORDER BY CC.CABLE_NUMBER ;
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…