This discussion is archived
11 Replies Latest reply: Jan 30, 2013 3:20 PM by 985917 RSS

sql developer

985917 Newbie
Currently Being Moderated
hello everyone,
am using sqlplus on my cmd and at the sametime I started using sql developer, when I run an insert statement on my cmd>>sqlplus I don't see the result on sql developer!!
anyone?
Thank you
  • 1. Re: sql developer
    phaeus Pro
    Currently Being Moderated
    Hello,
    are you on the same schema? Did your commit your changes?

    regards
    Peter
  • 2. Re: sql developer
    Rahul_India Journeyer
    Currently Being Moderated
    982914 wrote:
    hello everyone,
    am using sqlplus on my cmd and at the sametime I started using sql developer, when I run an insert statement on my cmd>>sqlplus I don't see the result on sql developer!!
    anyone?
    Thank you
    You cant use cmd>>sqlplus in sql developer.
    You have to create connections in sql developer
    what are you trying to achieve?

    Edited by: Rahul India on Jan 28, 2013 4:46 AM
  • 3. Re: sql developer
    Solomon Yakobson Guru
    Currently Being Moderated
    982914 wrote:
    when I run an insert statement on my cmd>>sqlplus I don't see the result on sql developer!!
    Did you commit after inserting? SQL*PLus & SQL*Developer sessions are two separate sessions. And session can't see other session uncommitted changes.

    SY.
  • 4. Re: sql developer
    985917 Newbie
    Currently Being Moderated
    Yes I did, so I was able to pull up the data from the tables however in my cmd>sqlplus my table name is for instance table1, in sql developer to select the data I had to do select * from sys.table1.. I don't understand why
  • 5. Re: sql developer
    985917 Newbie
    Currently Being Moderated
    Well I am trying to select * from a table on sql developer, but the data was first inserted into cmd>sqlplus
  • 6. Re: sql developer
    985917 Newbie
    Currently Being Moderated
    I did
  • 7. Re: sql developer
    sb92075 Guru
    Currently Being Moderated
    when all else fails, Read The Fine Manual

    http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm
  • 8. Re: sql developer
    Rahul_India Journeyer
    Currently Being Moderated
    982914 wrote:
    Well I am trying to select * from a table on sql developer, but the data was first inserted into cmd>sqlplus
    can i see yor insert and select command
    are you connected to same schema?
  • 9. Re: sql developer
    985917 Newbie
    Currently Being Moderated
    on sqlplus

    insert into E_SERVICE
    values(1, 'Achat');
    insert into E_SERVICE
    values(2, 'Vente');
    insert into E_SERVICE
    values(3, 'Comptabilité');
    insert into E_SERVICE
    values(4, 'Entretien');

    so they re inserted and if I wanna see them : select * from E_service;

    I was able to select them in sql developer but I had to use select * from sys.e_service
  • 10. Re: sql developer
    sb92075 Guru
    Currently Being Moderated
    982914 wrote:
    on sqlplus

    insert into E_SERVICE
    values(1, 'Achat');
    insert into E_SERVICE
    values(2, 'Vente');
    insert into E_SERVICE
    values(3, 'Comptabilité');
    insert into E_SERVICE
    values(4, 'Entretien');

    so they re inserted and if I wanna see them : select * from E_service;

    I was able to select them in sql developer but I had to use select * from sys.e_service
    you should NOT be creating any new objects, like E_SERVICE table, within SYS schema
  • 11. Re: sql developer
    985917 Newbie
    Currently Being Moderated
    thank u all, i realized i m using the sys shema

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points