Forum Stats

  • 3,757,167 Users
  • 2,251,204 Discussions
  • 7,869,748 Comments

Discussions

no output showing

3134376
3134376 Member Posts: 150
edited Jan 10, 2019 9:08PM in SQLcl

Hi

sqlcl is not showing anyoutput, only working with dual nor showing any other query output ?

pastedImage_0.png

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,782 Bronze Crown
    edited Jan 10, 2019 9:08PM

    Is fnd_users actually a table, or is it a view, perhaps on fnd_user?

    If it is a view then there may be something in the where clause limiting what you can select.

    If it is a new install,then the table will be empty until apps users are created.

    sqlcl is not at fault here...