Hi,
I am not a Progress expert and would like to know Progress Equivalent SQL Stmts for following oracle queries for one of our project. I'd really appreciate if some one could help. Thanks.
1)
ANALYZE TABLE $table_name ESTIMATE STATISTICS
2)
SELECT acocl.column_name,acocl.position FROM all_constraints ac , all_cons_columns acocl WHERE ac.owner = acocl.owner AND ac.constraint_name = acocl.constraint_name AND ac.owner = '$tableOwner' AND ac.table_name = '$tablename' AND ac.constraint_type = 'P' AND ac.status = 'ENABLED'
3)
ALTER TABLE $table_owner.$table_name MODIFY CONSTRAINT $constraint_name DISABLE
4)
SELECT INDEX_OWNER,INDEX_NAME FROM ALL_IND_COLUMNS WHERE TABLE_NAME = '$table_name' AND COLUMN_NAME = '$column_name' AND TABLE_OWNER='$table_owner'
5)
SELECT username,username FROM all_users WHERE username NOT IN ('SYS','SYSTEM','CTXSYS') order by 1
6)
SELECT table_name,owner FROM all_tables WHERE table_name IN ('$tableName')
7)
SELECT sum($column_name) FROM $table_name WHERE 1 = 1
I am not a Progress expert and would like to know Progress Equivalent SQL Stmts for following oracle queries for one of our project. I'd really appreciate if some one could help. Thanks.
1)
ANALYZE TABLE $table_name ESTIMATE STATISTICS
2)
SELECT acocl.column_name,acocl.position FROM all_constraints ac , all_cons_columns acocl WHERE ac.owner = acocl.owner AND ac.constraint_name = acocl.constraint_name AND ac.owner = '$tableOwner' AND ac.table_name = '$tablename' AND ac.constraint_type = 'P' AND ac.status = 'ENABLED'
3)
ALTER TABLE $table_owner.$table_name MODIFY CONSTRAINT $constraint_name DISABLE
4)
SELECT INDEX_OWNER,INDEX_NAME FROM ALL_IND_COLUMNS WHERE TABLE_NAME = '$table_name' AND COLUMN_NAME = '$column_name' AND TABLE_OWNER='$table_owner'
5)
SELECT username,username FROM all_users WHERE username NOT IN ('SYS','SYSTEM','CTXSYS') order by 1
6)
SELECT table_name,owner FROM all_tables WHERE table_name IN ('$tableName')
7)
SELECT sum($column_name) FROM $table_name WHERE 1 = 1
