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
Questions tagged [data-dictionary]
187 questions
2
votes
1 answer
Order table names by foreign key constraint (i.e. table x record needs to exist before table y record can be created)
Is there any way to query the data dictionary to get a list of tables in the order in which they should be populated.
I have a project where I am doing bulk inserts on a large number of tables and it would be hugely helpful if I could get a list of…
John
- 3,458
- 4
- 33
- 54
2
votes
1 answer
How to retrieve all the columns from all of the tables in a particular database which are not part of primary keys and foreign keys
I am really new to Stackoverflow apologies for any mistakes.
I am working on Qlikview. It doesn't allow the columns which are of same name in two different tables. I used to create aliases for each and every column every time when i need to import…
Munny
- 67
- 1
- 10
2
votes
2 answers
How to create two compound foreign keys in ABAP
I got three tables. user tag and user_tag. The primary of user is iduser+client, the one of tag is idtag+client. Now I want to create foreign keys for the table user_tag for those two primary keys without having client twice in there.
How can I do…
inetphantom
- 2,498
- 4
- 38
- 61
2
votes
2 answers
HUGE query execution time difference between oracle 10g and 9i
I'm running the following query:
SELECT * FROM all_tab_cols c
LEFT JOIN all_varrays v ON c.owner = v.owner
AND c.table_name = v.parent_table_name
AND c.column_name = v.parent_table_column
On a 10g server this takes ~2s, on 9i this takes…
thecoop
- 45,220
- 19
- 132
- 189
2
votes
1 answer
Where is all_nested_table_cols in 9i?
Oracle 9i has nested tables, however it doesn't have the all_nested_table_cols sysview (like 10g and 11g) which lets me see what the columns are for these nested tables. How can I find this information on a 9i database?
thecoop
- 45,220
- 19
- 132
- 189
2
votes
0 answers
DBA_HIST_TBSPC_SPACE_USAGE duplicate SNAP_ID
I'm not entirely sure if this is a bug or something that I'm doing wrong, but here goes:
I'm trying to pull historical tablespace information from the DBA_HIST_TBSPC_SPACE_USAGE data dictionary view. The documentation says that the snap_id value is…
Mr. Llama
- 20,202
- 2
- 62
- 115
2
votes
1 answer
different number of tables from user_tables and user_objects query
under the same schema, I got different number of tables from the following two queries:
select object_type,count(*) from user_objects group by object_type;
output: i got 17 for table from object_type column.
another query:
select count(*) from…
stephanie
- 75
- 1
- 1
- 3
2
votes
1 answer
Tuning of query with ALL_OBJECTS view
I need help in tuning following query involving querying from Oracle data dictionary ALL_OBJECTS.
SELECT OBJECT_NAME ,OBJECT_TYPE
FROM ALL_OBJECTS OBJ
WHERE (OBJ.OWNER ='HR')
AND (OBJ.OBJECT_TYPE IN ('TABLE','VIEW'));
I tried tuning query using…
Sid
- 582
- 3
- 7
- 28
2
votes
3 answers
How to save results of a SQL query to html file?
I am running a SQL script I found online. The script generates a data dictionary from extended properties data. How can I save the results to an HTML file?
I prefer not changing the defaults, however I tried going into SQL server > Tools > Options…
P.Brian.Mackey
- 43,228
- 68
- 238
- 348
2
votes
2 answers
Table -> Function dependency via a virtual column not in all_dependencies?
I've got the following objects:
CREATE FUNCTION CONSTFUNC RETURN INT
DETERMINISTIC
AS
BEGIN
RETURN 1;
END;
CREATE TABLE "FUNCTABLE" (
"ID" NUMBER(*,0) NOT NULL,
"VIRT" NUMBER GENERATED ALWAYS AS ("CONSTFUNC"()) NULL
);
however, the functable…
thecoop
- 45,220
- 19
- 132
- 189
2
votes
1 answer
Double value in Dictionary
I have this code to get two double from jSon:
Dictionary dict = this.GetDicFromInput();
Decimal tmpLat = (Decimal)dict["lat"];
Decimal tmpLon = (Decimal)dict["lon"];
This is GetDicFromInput:
private Dictionary…
YosiFZ
- 7,792
- 21
- 114
- 221
2
votes
4 answers
Dictionaries inside a List :: Merging Values for the Same Keys
I have multiple dictionaries inside a Python List as below
[{"color": "#CC3", "values": {"y": 83, "x": 9}, "key": 105},
{"color": "#CC3", "values": {"y": 123, "x": 10}, "key": 105},
{"color": "#FF9", "values": {"y": 96, "x": 11}, "key": 106},
…
SANKAR
- 31
- 1
- 5
2
votes
1 answer
finding non anchored variable in oracle package
How can we find all the variables in the package, that are not declared as anchored.
Suppose I have a package as shown below:
create or replace pkg body test
is
TYPE AnEntry IS RECORD (
term VARCHAR2(20), --TERM IS NOT ANCHORED
meaning…
Gaurav Soni
- 6,278
- 9
- 52
- 72
1
vote
3 answers
Exploring data dictionary tables usage in Oracle?
I am fresher and just started learning about database. But one thing strikes me, being a PL/SQL I should know all the data dictionary table, rather than relying on the options given in TOAD, SQL Developer. Like explain plan, search an object, locks,…
Gaurav Soni
- 6,278
- 9
- 52
- 72
1
vote
1 answer
How do you tell if a particular column is in a table?
I would like to know what query to use to determine if a particular table column exists in a given table.
For example I would like to know if the column named Address_1 exists in the table named Visits.
I think it is in a data dictionary table…
Emad-ud-deen
- 4,734
- 21
- 87
- 152