Stack Overflow
Stack Overflow

Questions tagged [data-dictionary]

A Data Dictionary stores information about all user-defined objects in the database. It usually comes with utilities to cross-reference all system components to each other.

References

187 questions
0
votes
0 answers

How to get Oracle procedure comments from data dictionary

How do I get Oracle procedure comments from the data dictionary (catalog) tables? Is there something similar to ALL_TAB_COMMENTS? Background: The Oracle JDBC driver gives back a comment of "Standalone procedure or function" for a procedure, and…
Sualeh Fatehi
  • 4,700
  • 2
  • 24
  • 28
0
votes
1 answer

How do I get the value of a Simulink struct from the workspace within a MATLAB function?

I need to access the values of variables in MATLAB's workspace of type Simulink.parameter: CAL_vars = dsdd('find','/path/CAL','ObjectKind','Variable','Property',{'name' 'Class' 'value' 'CAL'}) %gets ids of variables in data dictionary i = 10 for…
user145760
  • 124
  • 9
0
votes
1 answer

Oracle Data Dictionary best practices and guidelines

It is best practice to have PL/SQL code in my application that queries Oracle Data Dictionary views (all_tab_columns, etc...)? Should this views be only used for DBA's and developers as they daily basis work? Example: I need to verify if a variable…
milheiros
  • 621
  • 2
  • 14
  • 34
0
votes
0 answers

JPA data dictionary structure

I define two table data structure in 3 tables , Table Groups and Table Persons for example table person : 1) define table name in Tables 2) field of person define in table Fields . 3) data inserted in table Data . so , john is a row…
user9321096
0
votes
1 answer

Oracle TABLE_PRIVILEGES Column Explanation

I queried the data dictionary TABLE_PRIVILEGES for one my user table to check the grants. It listed me 34 rows out of which for some of the records the value of SELECT_PRIV column is Y and for few of them it's G. I believe Y stands for YES but I am…
Parvej Islam
  • 55
  • 1
  • 5
0
votes
1 answer

Logic/reasoning confusion in UGC book re network/relational logical/physical keys & schema/metatdata/dictionary

I was just going through the questions of UGC-NET(GS) & GATE(CS/IT), in which I had some difficulties. There are some questions whose answers are different than my answers. Can you help me find the solution and tell me whether I am wrong or the…
Bhavya
  • 53
  • 1
  • 8
0
votes
1 answer

Oracle PL/SQL modify column DEFAULT_LENGTH attribute

I have attribute DEFAULT_LENGTH in bellow select: SELECT TABLE_NAME, COLUMN_NAME, DATA_DEFAULT, DEFAULT_LENGTH FROM all_tab_columns WHERE TABLE_NAME LIKE 'TEST2'; For changing DATA_DEFAULT I used below syntax: ALTER TABLE TEST2 MODIFY…
Catalin
  • 253
  • 8
  • 21
0
votes
5 answers

Javascript Array To Lookup Key Value Pairs

I would like to be able to create an object that I could use in conjunction with the following code that could convert keycodes into the appropriate key name. $(document).keydown(function(event) { var keycode = (event.keyCode ? event.keyCode :…
Realto619
  • 83
  • 2
  • 7
0
votes
1 answer

How can I exclude a "report.specification" from a Report in Enterprise Architect?

I am attempting to generate a data dictionary for a package, but I cannot figure out how to exclude the report that is my data dictionary. I get this item: in my generated PDF on the last page: I have tried Generate Documentation ➜ Exclude…
Jay Cummins
  • 1,039
  • 2
  • 14
  • 31
0
votes
1 answer

SQL query of my table rights given through a role?

I need to build a query that returns the tables I have access to because of rights given to me through a role with the data dictionary.
Ryan
  • 1
0
votes
1 answer

Mapping Data in R with missing values

I'm very new with R, and I'm trying to map data dictionary definitions to a set of data to make more readable text. For example, based on the data dictionary within the Ames Iowa housing dataset currently on Kaggle, I'm trying to map the zoning of…
Mike Weier
  • 1
  • 1
0
votes
1 answer

Get right data from dict inside list

I'm trying to get a video URL from tweet, A was taken from tweepy. Because twitter doesn't tell which one is the highest quality video I assume that I have to compare highest 'bitrate' and store the 'url' that corresponds with it. This is what I…
Yoga Yudistira
  • 13
  • 3
0
votes
1 answer

Comparing Multiple Values from one table to Multiple Values in another

I have a PL/SQL stored function script I am writing and I have run into a problem. I need to find ALL Applicants who possess ALL the skills needed for a task and display them. I have a method where I have individually read in Applicant's skills…
Brett Latham
  • 1
0
votes
1 answer

Data Dictionary and Oracle Advice needed

I have four tables called (to make the post easier to understand) a,b,c and d. I have created a data dictionary for them all, with all attributes and other information needed. I am confused on whether or not I have to include my many-to-many tables…
Khush
  • 51
  • 8
0
votes
1 answer

SQL to retrieve Oracle Function Parameters

Is there any way to pull from the data dictionary the parameters for a particular function? I've seen some query tools display this information and I'm wondering if they are parsing the DDL or if Oracle stores this information somewhere. Thank…
Todd Wilson
  • 71
  • 5
1 2 3
…
12 13