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
1
vote
0 answers

How can I get the Schema changes between two database release‎

I have to note down the changes made in new database version. Those are new tables, new columns, data type changes in newer version. We can get all tables info from all_tables and columns and datatype info from all_tab_columns. By using these data…
1
vote
1 answer

List all procedures along with the tables and columns used in that procedure in Oracle

Last night got a call from my team lead and he asked me to make the list of all the procedures along with the tables and columns used in Oracle. I got a query to list all the procedures along with tables and dblink but couldn't get column names…
Karthick
  • 816
  • 1
  • 9
  • 21
1
vote
0 answers

How to insert similar value into multiple locations of a psycopg2 query statement using dict?

Datetimes are contained in the following dict: datetimes = { 'start': datetime.strptime(args.start,"%Y-%m-%d %H:%M:%S").replace(tzinfo=pytz.UTC), 'end' : datetime.strptime(args.end,"%Y-%m-%d %H:%M:%S").replace(tzinfo=pytz.UTC) } Here is an…
Alex Willison
  • 257
  • 7
  • 20
1
vote
1 answer

How can I include a clickable (hyperlinks) table of contents when generating documents in Enterprise Architect?

I have a data dictionary report in Enterprise Architect (same as in this question: How can I exclude a "report.specification" from a Report in Enterprise Architect?) and I would like a table of contents that is clickable (has links). The current…
1
vote
2 answers

ALL_COL_COMMENTS doesn't return all table objects given a certain user

When logged in as the schema owner, I can run a query select * from ALL_COL_COMMENTS WHERE TABLE_NAME LIKE 'BLEH_%'; And I can see all the tables and columns that I expect. However, if I login as a different user, the same query will return some…
Jack B Nimble
  • 5,039
  • 4
  • 40
  • 62
1
vote
2 answers

QuickFIX counterparty DataDictionary gieves invalid type exception

I am developing a FIX4.4 messaging application in C# and trying to use a counterparty provided data dictionary. In the project I use QuickFIX as a library, and when using the original dictionary provided within the library (FIX44.xml) everything…
GPP
  • 46
  • 6
1
vote
1 answer

Concatenating multiple data dictionaries in python

I have created multiple data dictionaries with year_quarter key. Then I used .describe() on one of the columns I was interested to study, column A. Now I want to create a DataFrame with the statistics created with .describe(). This is what I…
Ana
  • 1,516
  • 3
  • 15
  • 26
1
vote
1 answer

How to find tables with no foreign keys?

Is there a query or command that shows which tables have no foreign keys?
Doug K
  • 88
  • 5
1
vote
3 answers

Getting Schemas from Oracle DB throwing error

This query select distinct owner from dba_objects is throwing this error ORA-00942: table or view does not exist Does that make any sense at all?
user2665166
  • 441
  • 4
  • 8
  • 17
1
vote
1 answer

oracle 10g ~ getting local user list

In Oracle 11g, they have a column called Authentication_Type in the dba_users table, using which we can get the list of local users created using password with the simple following query: select USERNAME from DBA_USERS where AUTHENTICATION_TYPE =…
Shanmugavel
  • 23
  • 1
  • 4
1
vote
1 answer

How to bind a complex dictionary to a Gridview in asp.net?

I've used an early binding of a dictionary to a gridview to show Urls Text and its HRef as key-value and it works like a charm. But since I want to replace the dictionary with this one : dictionary the binding…
Mehdi
  • 125
  • 11
1
vote
1 answer

regex to parse well-formated multi-line data dictionary

I am trying to read and parse a data dictionary for the Census Bureau's American Community Survey Public Use Microsample data release, as found here. It is reasonably well formated, although with a few lapses where a few explanatory notes are…
ako
  • 3,569
  • 4
  • 27
  • 38
1
vote
0 answers

How to include user type column in data dictionary - Visual Paradigm

Designed a data model with ER diagram. Defined Both user type and data type for all columns. But when i try to generate report and produce data dictionary , user type column is not included. So is it possible to include User type column in the data…
Chatosh
  • 51
  • 1
  • 3
1
vote
2 answers

join between v$sql and v$session with specifiq condition

I am trying to join the both tables v$sql and v$session my aim of this query is to know who is the user that is using the machine and what is the sql that his using. I am searching for something similar select s.sql_text , i.osuser from…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
1
vote
0 answers

How to connect data dictionaries to the unlabeled data

I'm working with some large government datasets from the Department of Transportation that are available as tab-delimited text files accompanied by data dictionaries. For example, the auto complaints file is a 670Mb file of unlabeled data (when…
Chris Wilson
  • 6,599
  • 8
  • 35
  • 71