# Oracle's SYS\_GUID() and loadData from csv from maven?

**URL:** <https://forum.liquibase.org/t/oracles-sys-guid-and-loaddata-from-csv-from-maven/1253>\
**Category:** General Discussion\
**Created:** [May 5, 2011, 12:20pm UTC](https://forum.liquibase.org/t/oracles-sys-guid-and-loaddata-from-csv-from-maven/1253 "2011-05-05T12:20:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wackyshaun](https://avatars.discourse-cdn.com/v4/letter/w/97f17d/32.png) [@wackyshaun](https://forum.liquibase.org/u/wackyshaun)\
**Post date:** [May 5, 2011, 12:20pm UTC](https://forum.liquibase.org/t/oracles-sys-guid-and-loaddata-from-csv-from-maven/1253/1 "2011-05-05T12:20:00Z")

</div>

Hi,

I am trying to use loadData in a changeset that loads from a csv file. &nbsp;For one column I want to use Oracles SYS\_GUID() function to get the value.

I have tried various ways to get it to work but it either ends up putting the literal “SYS\_GUID()” string as the value or missing the closing parentheses.

I think the way I should do it is have the column defined as “NUMERIC” and not add quites for the value (…,SYS\_GUID(),…) but when I do, the sql generated for the value is missing the right parentheses like:

…, SYS\_GUID(, …

Anyone have an idea of how I could do this?

Thanks.

---

<div class="post-metadata">

**Author:** ![taranenko](https://avatars.discourse-cdn.com/v4/letter/t/ee7513/32.png) [@taranenko](https://forum.liquibase.org/u/taranenko)\
**Post date:** [May 5, 2011, 12:20pm UTC](https://forum.liquibase.org/t/oracles-sys-guid-and-loaddata-from-csv-from-maven/1253/2 "2011-05-05T12:20:00Z")

</div>

change column definition to DEFAULT SYS\_GUID() and do not import the column from the csv file
