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)