Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number Column result set in 9i prefixed with a 'G'

Status
Not open for further replies.
taregeek

taregeek

Programmer
Joined
Jan 23, 2005
Messages
1
Location
US
We have updated to Oracle 9i and when we query a number field without precision it is always prefixed with a 'G'.

Ex. should return '1234' actually returns 'G1234'.

Same query in SQL plus does not return 'G'...
 
Sort by date Sort by votes
If you do a Str.String function around the result the "G" should go away.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ekta Singh 2
  • Locked
  • Question Question
Embedded Docusign in Xecm successfactor
Replies
0
Views
784
Ekta Singh 2
Ekta Singh 2
RajPesari
  • Locked
  • Question Question
Upload restriction for html files in content server
Replies
4
Views
932
appnair
appnair
sherriffot
  • Locked
  • Question Question
Error creating index on EDOCS Server Manager
Replies
0
Views
698
sherriffot
sherriffot
JokerK
  • Locked
  • Question Question
Unable to Upload documents in Content Server 22.2
Replies
1
Views
1K
ggriffit
ggriffit
MRefaii
  • Locked
  • Question Question
DTreeACL Table - Permissions Column
Replies
2
Views
711
ggriffit
ggriffit

Part and Inventory Search

Sponsor

Back
Top