或者是否有任何分析数据字典来告诉我,哪些表格正在(译文)观点中参考?
我愿指出,在DML中使用了哪些表格。 我更喜欢使用一套专册,因为它可以自行载于数据库。
但其他建议值得欢迎。 公开来源非常受欢迎。
Here is the link to the syntax diagram of the table_reference definition: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2126863
是否有任何教区?
Venkataramesh的回答(dba_snapshots)只提供了部分答案,因为照片涉及多个表格和(或)观点,以便获得你能够使用美国传真的所涉物体的完整清单。 PDENDENCIES 认为:
select name, type, referenced_name, referenced_type
from user_dependencies
where type = MATERIALIZED VIEW
order by name
采用数据字典观点dba_snapshots。 它有主栏,说明所用/参考的总表格。
$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...
I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...
I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...
Does anybody know if it is possible to move some (not all) users from one ASP.NET membership database to another? (for the purposes of migrating some users to another database on another machine, but ...
Is it because of size? By the way, what is the limit of the size?
I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...
For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...
I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...