Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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