Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 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
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
What are the functions used for adding Column level and Table level UDP's

What are the functions used for adding Column level and Table level UDP's checked Index.html couldn't find anything.
Best Answers
-
There is support for dynamic properties - it's a pair <name,value> and you can use following methods on each object:
void setProperty(String key, String value);
String getProperty(String key);
boolean hasProperty(String key);
boolean hasProperty(String key, String value);
void removeProperty(String key);
void clearProperties();
UDP has additional metadata - you need to define them at design level but at the core they are dynamic properties. Once defined UDP can be managed using methods above.
Both UDP and dynamic properties can be used in reports, UDPs can appear on diagram.
Philip
-
For UDP you need to create them manually in UDP library in design properties dialog.
Answers
-
There is support for dynamic properties - it's a pair <name,value> and you can use following methods on each object:
void setProperty(String key, String value);
String getProperty(String key);
boolean hasProperty(String key);
boolean hasProperty(String key, String value);
void removeProperty(String key);
void clearProperties();
UDP has additional metadata - you need to define them at design level but at the core they are dynamic properties. Once defined UDP can be managed using methods above.
Both UDP and dynamic properties can be used in reports, UDPs can appear on diagram.
Philip
-
Hi Philip,
Thanks for response.
Tried setProperty(String key, String value); function for table level and column level instead of User Defined Property(UDP) please refer the screen shots attached where in Dynamic property is getting set.
Kindly help us with the function name to set User Defined Property(UDP).
Also want to understand what is the difference between Dynamic property and User Defined Property(UDP).
Regards
Rohit Puranik
-
For UDP you need to create them manually in UDP library in design properties dialog.
-
Thanks for your response Philip.
We are having once requirement in which we want to achieve this using scripting rather then manually.
Please suggest some function using that in our script we could create User defined propery automatically instead of manually.
Regards
Rohit
-
Thanks a lot Philip that worked....!!