Hello. How to get the names of the required columns? Not "api_datasource.getRequiredColumnViolations".

asked 28 Jan '15, 14:03

Ramil's gravatar image

Ramil
41217
accept rate: 0%


Hi, i do it in a 'dirty' way

As required Columns are not nullable

select column_name from ALL_TAB_COLUMNS
where table_name = '{YouTableName}'
and nullable = 'N'

regards Dirk

link

answered 29 Jan '15, 10:30

Dirk's gravatar image

Dirk
134
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×16
×5
×3

Asked: 28 Jan '15, 14:03

Seen: 803 times

Last updated: 29 Jan '15, 10:30


© Copyright Gerger 2017