مساعدة : مطلوب عمل query لمعرفة اسم الجدول وبجانبه عدد الصفوف التي بداخله

[asd13]

السلام عليكم

مطلوب مني عمل query لمعرفة اسم الجدول وبجانبه عدد الصفوف التي بداخله
وجزاكم الله خير

[mw_wageeh]

select table_name,NUM_ROWS from user_tables

[asd13]

جزاك الله كل خيرا يأباشمهندس

ياريت أفكار تانية يإخواني الاعزاء اصل مطلوب مني كذا طريقة

وشكرا مرة اخرى باشمهندس محمد

[mageed_ahmed]

أخي الكريم

يمكنك باستخدام
DBA_TAB_COL_STATISTICS,DBA_TAB_COLUMNS,DBA_TAB_COLS, DBA_COL_COMMENTS

select column_name,data_type from cols where Table_name='TEST_TABLE'

COLUMN_NAME DATA_TYPE
------------------------------ --------------------
A NUMBER
B VARCHAR2
C CLOB


-------
Select COLUMN_NAME from user_tab_columns where table_name='EMP'

select column_name from all_tab_columns where table_name =upper('tablename');

--------
SELECT t.TypeOwner TypeOwner
FROM metaTable tab, metaType t
WHERE tab.TypeName = t.TypeName"


--------
لذلك

ALL_TABLES - list of all tables in the current database that are accessible to the current user
ALL_TAB_COLUMNS - list of all columns in the database that are accessible to the current user
ALL_ARGUMENTS - lists the arguments of functions and procedures that are accessible to the current user
ALL_ERRORS - lists descriptions of errors on all stored objects (views, procedures, functions, packages, and package bodies) that are accessible to the current user
ALL_OBJECT_SIZE - included for backward compatibility with Oracle version 5
ALL_PROCEDURES - (from Oracle 9 onwards) lists all functions and procedures (along with associated properties) that are accessible to the current user
ALL_SOURCE - describes the text (i.e. PL/SQL) source of the stored objects accessible to the current user


ولعد الصفوف داخل أعمدتها

COLUMN DUMMY NOPRINT
 COMPUTE SUM OF NUM_ROWS ON DUMMY
 BREAK ON DUMMY
 SELECT
    NULL DUMMY,
    T.TABLE_NAME,
    C.COLUMN_NAME,
    T.NUM_ROWS
 FROM
    ALL_TABLES T,
    ALL_TAB_COLUMNS C
 WHERE
    T.TABLE_NAME = C.TABLE_NAME
    AND C.COLUMN_NAME LIKE '%PATTERN%'
 ORDER BY T.TABLE_NAME;

تحياتي لك