0

I have a table in oracle server like that (keyid with 20 digits)

enter image description here

when I import this table with odbc package it ROUNDS the key ids.

df <- sqlQuery(dwh, "select keyid from mytable")

(I already use options(scipen=999) not to show as e)

How can I get this keyid as text or sometihng else not to round the keyid?

Thanks!!

determinator
  • 129
  • 1
  • 1
  • 5
  • Does this answer your question? https://stackoverflow.com/questions/10823298/sqlquery-impossible-to-get-the-id-number-as-character-into-r – Otto Kässi Aug 06 '20 at 08:53
  • 1
    Does this answer your question? [sqlQuery: impossible to get the ID number as Character into R?](https://stackoverflow.com/questions/10823298/sqlquery-impossible-to-get-the-id-number-as-character-into-r) – Otto Kässi Aug 06 '20 at 08:54
  • did not work sorry... – determinator Aug 19 '20 at 16:24

0 Answers0