144 reputation
6
bio website
location
age
visits member for 1 year, 9 months
seen Jun 4 at 12:40

Jul
30
awarded  Popular Question
Apr
3
answered Oracle: Table or View does not exist in Tree
Apr
2
comment Oracle: Table or View does not exist in Tree
However, everything else works: if I create a table I can do a select statement on it without problem.
Apr
2
awarded  Commentator
Apr
2
comment Oracle: Table or View does not exist in Tree
I just recreated the database to make sure that its not a broken thing there, but I still have the same problem. If I log in as sys and perform a select on dba_users, I get a "ORA-00942: table or view does not exist" error
Apr
2
comment Oracle: Table or View does not exist in Tree
I get a "ORA-00942: table or view does not exist" error.
Apr
2
revised Oracle: Table or View does not exist in Tree
edited body
Apr
2
comment Oracle: Table or View does not exist in Tree
What about a tabe dba_users. It seems that I cannot perform a SELECT * FROM dba_users as sys with sysdba. What are the names of the system tables?
Apr
2
revised Oracle: Table or View does not exist in Tree
deleted 157 characters in body; edited title
Apr
2
comment Oracle: Table or View does not exist in Tree
Honestly, I don't know. I just have this script generating the SQL code I should run in Oracle.
Apr
2
comment Oracle: Table or View does not exist in Tree
It is currently even worse: when I login using CONNECT as oracle/pass as sysdba and I try to SELECT * FROM sys.all_tables I get the ORA-00942 error (table or view does not exist). What is broken?
Apr
2
asked Oracle: Table or View does not exist in Tree
Mar
20
accepted PostgresSQL: Get single attribute of UDT in SELECT statement
Mar
20
comment PostgresSQL: Get single attribute of UDT in SELECT statement
Thanks! The difference is very subtle. Btw, I thought it might be somewhere written in the manual, but I really couldn't find it. Thanks again!
Mar
20
awarded  Editor
Mar
20
revised PostgresSQL: Get single attribute of UDT in SELECT statement
deleted 3 characters in body; added 76 characters in body; edited title
Mar
20
asked PostgresSQL: Get single attribute of UDT in SELECT statement
Feb
28
answered Postgresql: type_modifier in UDT
Feb
27
comment Display user-defined types and their details
Thanks a lot for the code and the explanations. Just one thing: what do you mean by ´\d...´ commands?
Feb
27
awarded  Supporter