Results 1 to 2 of 2

Thread: whay the output no rows selected?

  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Question whay the output no rows selected?

    this is my question:

    The developers Roger and Siw has encountered some problems. Roger works as a DBA and are doing to fill in a table called the article with data. The table schema is owned by the shop. Siw talked to Roger that she did not see any data about the articles in the table article. Siw look at the table in a web interface that she is developing.
    Roger sitting at a computer named pcadmin-01 and are logged to the database with the name webb.oracle9.se on port 1599. He has just executed the following SQL code:
    INSERT INTO webbshop.artikel (Item, common name, price)
    VALUES (artnr.NEXTVAL, 'SPADE', 475);

    As Roger writes SELECT * FROM webbshop.artikel he receives the following output:
    Item species name price
    1 SPADE 475

    When Siw run the same select statement from their computer (another computer) so she gets the following output:
    no rows selected

    My task is to solve their problems, and to explain the background to the errors of this type occurs.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do you have Virtual Private Database setup?. This will restrict users to their own data by adding WHERE clause to every query they run.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •