Forum Stats

  • 3,872,608 Users
  • 2,266,458 Discussions


How can I see the sql statement of a view (db resides on AWS)

I've just installed the vscode extension and successfully connected the db.

The db resides on AWS.

I can connect the db and just wanted to test it by opening an existing view.

But, it just lets me "describe" the view. So I can see the columns but I need to edit the query statement.

What's missing? Or is the problem the AWS part?


Best Answer

  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 2,241 Employee
    Answer ✓

    You greyed out the view name, so I cannot check to see if you have a typo which is the first thing I would suspect.

    Did you give the view name in all caps, surrounded by single quotes?

    Maybe you can create a view called TESTVIEW and run this again using 'TESTVIEW' as the second parameter and share the full error message without greying it out.

    Finally, please issue:

    select owner from ALL_VIEWS where VIEW_NAME ='NAMEOFYOURVIEW';

    If that is NOT AWS_DEV_ALB then you will need to change the pl/sql block accordingly.