Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
returning wrong ID from query

hello guys i not really expert on oracle . I am a python developer and i have too work with oracle 11 G in a project .
I have a simple table with 3 field the problem is the first field .
I have created the numeric field called ID and after that i created a sequence and a trigger for that to build an auto increment primary key field.
everything works fine but there is a problem. when i use query to get data from table like SELECT id FROM table , the query returns ids started from 1 to end (like rownum) and not the real id from datas and ids is really important to me to get some slice of the return of query and do some thins
my python is 3.6.8
lib is cx_oracle
db version is oracle 11G standard eddition
Answers
-
is there any one here??
-
Too little detail to assist.
The query in Python is the #1 suspect though. A server typically does exactly what the client requests - which can be different than what you think you've requested.
You can copy and paste the query into command line sqlplus - in fact using sqlplus as a baseline testing tool for any and all Oracle client development is a primary recommendation.
-
I have a hunch that, when when you created the id field with a sequence, that was initiated with 1 and so on... so, basically if you refer to that column, you will only get the sequence like output
Could you share the table structure i.e. columns and primary keys and if possible some dummy data.
Regards,
Pratyush