lazy cat
User
Expert Boarder
| Posts: 63 |   |
Karma: 2
|
|
TADQuery/Query Editor...
|
|
Posted: 2005/08/11 19:41 |
|
|
|
|
Oracle 9.2
Пытается послать запрос
SELECT to_number(NULL) AS recno,
to_char(NULL) AS catalog_name,
owner AS schema_name,
object_name AS table_name,
decode(temporary,
'Y',
3,
decode(object_type, 'TABLE', 1, 'SYNONYM', 0, 2)) AS table_type,
decode(owner, USER, 0, 'SYS', 2, 'SYSTEM', 2, 1) AS table_scope
FROM dba_objects
WHERE object_type IN ('TABLE', 'VIEW', 'MATERIALIZED VIEW', 'SYNONYM') AND () AND
temporary = 'N'
ORDER BY 3, 4
- по причине пустой скобки в WHERE лезет ORA-00936
|
|
