KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Retrieving the list of table from an ORACLE database
PRODUCT: 4D Oracle | VERSION: 6.8 | PLATFORM: Mac & Win
Published On: September 16, 2003

Versions: 6.7.x, 6.8.x and 2003.x

Here is a simple method that will return the list of the table name from an ORACLE database.

  ` Method: Get_ORAUserTables
  ` $1 - Cursor ID
  ` $2 - Pointer to a text or string array
C_LONGINT($1;$curr_id;$result)
C_POINTER($2;$arTableName)
C_STRING(255;$sql)
$curr_id:=$1
$arTableName:=$2
$sql:="SELECT table_name FROM user_tables"
$result:=OD Execute SQL ($curr_id;$sql;-1;$arTableName)