This discussion is archived
1 Reply Latest reply: Jan 3, 2013 5:46 AM by Jeff Smith SQLDev PM RSS

Feature of SQL Developer

873006 Newbie
Currently Being Moderated
Hi Team

I want to know same option in SQL Developer

1) Is there any option to compare two schem in SQL Developer.
2) will execute the query like select * form emp ; count is 500 but in SQL developer i will not showing proper count.
why like that..?

Thanks
Suman
  • 1. Re: Feature of SQL Developer
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    1) Yes - Tools > Database Diff
    http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52sqldev-1735911.html This Oracle Magazine article takes you through the steps. We've updated the technology to make comparing schemas where you don't have login privs to the target schema easier in the latest and greatest version of SQL Developer. You can read about those updates here http://www.thatjeffsmith.com/archive/2012/09/using-database-diff-to-compare-schemas-when-you-dont-have-the-destination-user-password/

    2) Where are you looking at the count? Are you looking at the grid toolbar space where it says 'All rows fetched: X in Y seconds' or are you doing a physical row count in the grid? We don't have enough information in your question to properly answer it. What are you seeing vs what are you expecting to see?

    Edited by: Jeff Smith SQLDev PM on Jan 3, 2013 8:45 AM

Legend

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