Re: Showing tables (converting from MySQL to Oracle)

This is really a question for an Oracle list, but I happen to know of the following page which has been helpful to me in the past: https://gdsg.ngdc.noaa.gov/tiki/tiki-index.php?page=SqlNotes kgt Shane Presley wrote:

Hello, I've recompiled PHP to use Oracle, and been able to run a quick test script that looks like... <?php if ($c=OCILogon("user", "pw", "server")) { echo "Successfully connected to Oracle.\n"; OCILogoff($c); } else { $err = OCIError(); echo "Oracle Connect Error " . $err[text]; } ?> So now I'm going through and converting my MySQL code to Oracle. I've finished the connect functions, but getting hung up on how to do queries. For example the first query wants to SHOW TABLES. Not sure how to do this with Oracle calls? function get_tables($link) {

       $tableList = array();
       $query = "SHOW TABLES";
       $result = perform_query($query, $link);
       while($row = fetch_array($result)) {
               array_push($tableList, $row[0]);
       }

       return $tableList;

} function perform_query($query, $link) {

       if($link) {
               $result = mysql_query($query, $link) or die('Query

failed: ' . mysql_error());

       }
       else {
               die('No DB link');
       }

       return $result;

} Thanks! Shane