22:
206:
In addition there are equivalent views prefixed "USER_" which show only the objects owned by the current user (i.e. a more restricted view of metadata) and prefixed "DBA_" which show all objects in the database (i.e. an unrestricted global view of metadata for the database instance). Naturally the
553:
Note that NUM_ROWS records the number of rows which were in a table when (and if) it was last analyzed. This will most likely deviate from the actual number of rows currently in the table.
922:
Warning: This is incomplete with respect to multiple datatypes including char, varchar and timestamp and uses extremely old, deprecated dictionary views, back to oracle 5.
190:
ALL_ERRORS โ lists descriptions of errors on all stored objects (views, procedures, functions, packages, and package bodies) that are accessible to the current user;
196:
ALL_PROCEDURES โ (from Oracle 9 onwards) lists all functions and procedures (along with associated properties) that are accessible to the current user;
934:
pattern match to a single character and should be escaped if you are in fact looking for an underscore character in the LIKE clause of a query.
145:
958:
105:
39:
86:
43:
58:
65:
72:
1054:
141:. It is stored in two locations: data dictionary tables (accessed via built-in views) and a metadata registry.
1007:
54:
32:
1034:
199:
ALL_SOURCE โ describes the text (i.e. PL/SQL) source of the stored objects accessible to the current user;
187:
ALL_ARGUMENTS โ lists the arguments of functions and procedures that are accessible to the current user;
359:
Estimate a total number of rows in all tables containing a column name that matches PATTERN (this is
970:
175:
ALL_OBJECTS โ list of all objects in the current database that are accessible to the current user;
982:
281:
Find all tables that have at least one column that matches a specific PATTERN in the column name
153:
178:
ALL_TABLES โ list of all tables in the current database that are accessible to the current user;
1049:
966:
184:
ALL_TAB_COLUMNS โ list of all columns in the database that are accessible to the current user;
181:
ALL_VIEWS โ list of all views in the current database that are accessible to the current user;
130:
79:
134:
122:
126:
118:
164:
The total number of these views depends on the Oracle version, but is in a 1000 range.
1043:
962:
21:
973:. In January 2006, EMM was available only through Oracle consulting services.
969:. It stores administered metadata in a consistent format that can be used for
193:
ALL_OBJECT_SIZE โ included for backward compatibility with Oracle version 5;
987:
360:
138:
202:
ALL_TRIGGERS โ list all the triggers accessible to the current user.
943:
And then each literal underscore should be a double underscore: __
168:
149:
1008:"Communications Data Model Implementation and Operations Guide"
931:
207:
access to "DBA_" metadata views requires specific privileges.
137:
in a database. This information about information is known as
15:
215:
Find all Tables that have PATTERN in the table name
171:
data dictionary tables are few, and are as follows:
46:. Unsourced material may be challenged and removed.
937:Just add the following after a LIKE statement:
8:
926:Use of underscore in table and column names
167:The main built-in views accessing Oracle
106:Learn how and when to remove this message
999:
146:relational database management systems
121:provides information about all of the
7:
44:adding citations to reliable sources
355:Example 3: counting rows of columns
959:Oracle Enterprise Metadata Manager
14:
20:
557:Example 4: finding view columns
31:needs additional citations for
1:
930:The underscore is a special
152:-standard equivalent called
1071:
1035:article on Oracle Metadata
277:Example 2: finding columns
211:Example 1: finding tables
953:Oracle Metadata Registry
563:
365:
283:
217:
949:LIKE '%__G' ESCAPE '_'
40:improve this article
971:metadata publishing
957:The Oracle product
887:'%PATTERN%'
506:'%PATTERN%'
325:'%PATTERN%'
253:'%PATTERN%'
983:Information schema
599:'VARCHAR2'
561:Find view columns
160:Views for metadata
154:information schema
967:metadata registry
363:specific script)
116:
115:
108:
90:
55:"Oracle metadata"
1062:
1022:
1021:
1019:
1018:
1004:
918:
915:
912:
909:
906:
903:
900:
897:
894:
891:
888:
885:
882:
879:
876:
873:
870:
867:
864:
861:
858:
855:
852:
849:
846:
843:
840:
837:
834:
831:
828:
825:
822:
819:
816:
813:
810:
807:
804:
801:
798:
795:
792:
789:
786:
783:
780:
777:
774:
771:
768:
765:
762:
759:
756:
753:
750:
747:
744:
741:
738:
735:
732:
729:
726:
723:
720:
717:
714:
711:
708:
705:
702:
699:
696:
693:
690:
687:
684:
681:
678:
675:
672:
669:
666:
663:
660:
657:
654:
651:
648:
645:
642:
641:'NUMBER'
639:
636:
633:
630:
627:
624:
621:
618:
615:
612:
609:
606:
603:
600:
597:
594:
591:
588:
585:
582:
579:
576:
573:
570:
567:
549:
546:
543:
540:
537:
534:
531:
528:
525:
522:
519:
516:
513:
510:
507:
504:
501:
498:
495:
492:
489:
486:
483:
480:
477:
474:
471:
468:
465:
462:
459:
456:
453:
450:
447:
444:
441:
438:
435:
432:
429:
426:
423:
420:
417:
414:
411:
408:
405:
402:
399:
396:
393:
390:
387:
384:
381:
378:
375:
372:
369:
350:
347:
344:
341:
338:
335:
332:
329:
326:
323:
320:
317:
314:
311:
308:
305:
302:
299:
296:
293:
290:
287:
272:
269:
266:
263:
260:
257:
254:
251:
248:
245:
242:
239:
236:
233:
230:
227:
224:
221:
111:
104:
100:
97:
91:
89:
48:
24:
16:
1070:
1069:
1065:
1064:
1063:
1061:
1060:
1059:
1055:Oracle Database
1040:
1039:
1031:
1026:
1025:
1016:
1014:
1012:docs.oracle.com
1006:
1005:
1001:
996:
979:
955:
950:
941:
928:
920:
919:
916:
913:
910:
907:
904:
901:
898:
895:
892:
889:
886:
883:
880:
877:
874:
871:
868:
865:
862:
859:
856:
853:
850:
847:
844:
841:
838:
835:
832:
829:
826:
823:
820:
817:
814:
811:
808:
805:
802:
799:
796:
793:
790:
787:
784:
781:
778:
775:
772:
769:
766:
763:
760:
757:
754:
751:
748:
745:
742:
739:
736:
733:
730:
727:
724:
721:
718:
715:
712:
709:
706:
703:
700:
697:
694:
691:
688:
685:
682:
679:
676:
673:
670:
667:
664:
661:
658:
655:
652:
649:
646:
643:
640:
637:
634:
631:
628:
625:
622:
619:
616:
613:
610:
607:
604:
601:
598:
595:
592:
589:
586:
583:
580:
577:
574:
571:
568:
565:
559:
551:
550:
547:
544:
541:
538:
535:
532:
529:
526:
523:
520:
517:
514:
511:
508:
505:
502:
499:
496:
493:
490:
487:
484:
481:
478:
475:
472:
469:
466:
463:
461:ALL_TAB_COLUMNS
460:
457:
454:
451:
448:
445:
442:
439:
436:
433:
430:
427:
424:
421:
418:
415:
412:
409:
406:
403:
400:
397:
394:
391:
388:
385:
382:
379:
376:
373:
370:
367:
357:
352:
351:
348:
345:
342:
339:
336:
333:
330:
327:
324:
321:
318:
315:
313:All_Tab_Columns
312:
309:
306:
303:
300:
297:
294:
291:
288:
285:
279:
274:
273:
270:
267:
264:
261:
258:
255:
252:
249:
246:
243:
240:
237:
234:
231:
228:
225:
222:
219:
213:
162:
119:Oracle Database
112:
101:
95:
92:
49:
47:
37:
25:
12:
11:
5:
1068:
1066:
1058:
1057:
1052:
1042:
1041:
1038:
1037:
1030:
1029:External links
1027:
1024:
1023:
998:
997:
995:
992:
991:
990:
985:
978:
975:
954:
951:
948:
939:
927:
924:
869:'VIEW'
725:data_precision
659:data_precision
564:
558:
555:
366:
356:
353:
284:
278:
275:
218:
212:
209:
204:
203:
200:
197:
194:
191:
188:
185:
182:
179:
176:
161:
158:
114:
113:
28:
26:
19:
13:
10:
9:
6:
4:
3:
2:
1067:
1056:
1053:
1051:
1048:
1047:
1045:
1036:
1033:
1032:
1028:
1013:
1009:
1003:
1000:
993:
989:
986:
984:
981:
980:
976:
974:
972:
968:
964:
963:ISO/IEC 11179
960:
952:
947:
944:
938:
935:
933:
925:
923:
562:
556:
554:
364:
362:
354:
282:
276:
216:
210:
208:
201:
198:
195:
192:
189:
186:
183:
180:
177:
174:
173:
172:
170:
165:
159:
157:
155:
151:
147:
142:
140:
136:
132:
128:
124:
120:
110:
107:
99:
88:
85:
81:
78:
74:
71:
67:
64:
60:
57: โ
56:
52:
51:Find sources:
45:
41:
35:
34:
29:This article
27:
23:
18:
17:
1015:. Retrieved
1011:
1002:
961:(EMM) is an
956:
945:
942:
936:
929:
921:
773:', '
560:
552:
358:
280:
214:
205:
166:
163:
143:
117:
102:
93:
83:
76:
69:
62:
50:
38:Please help
33:verification
30:
965:compatible
940:ESCAPE '_'
863:object_type
851:object_name
791:')'
767:')'
755:')'
713:'('
635:')'
629:DATA_LENGTH
617:'('
575:column_name
500:COLUMN_NAME
434:COLUMN_NAME
319:Column_Name
307:Column_Name
295:Schema_Name
229:Schema_Name
148:support an
1044:Categories
1017:2022-07-05
994:References
902:table_name
881:table_name
839:TABLE_NAME
785:data_scale
743:data_scale
569:TABLE_NAME
545:TABLE_NAME
488:TABLE_NAME
476:TABLE_NAME
452:ALL_TABLES
422:TABLE_NAME
301:Table_Name
268:Table_Name
247:Table_Name
241:All_Tables
235:Table_Name
135:procedures
66:newspapers
914:column_id
809:data_type
803:DATA_TYPE
707:DATA_TYPE
695:DATA_TYPE
677:DATA_TYPE
611:DATA_TYPE
593:DATA_TYPE
96:July 2022
1050:Metadata
988:Metadata
977:See also
946:Example
446:NUM_ROWS
386:NUM_ROWS
361:SQL*Plus
139:metadata
377:COMPUTE
374:NOPRINT
131:columns
80:scholar
731:DECODE
647:DECODE
581:decode
566:SELECT
404:SELECT
368:COLUMN
286:SELECT
220:SELECT
144:Other
133:, and
123:tables
82:
75:
68:
61:
53:
890:ORDER
830:WHERE
533:ORDER
530:OWNER
518:OWNER
467:WHERE
410:DUMMY
401:DUMMY
395:BREAK
392:DUMMY
371:DUMMY
328:ORDER
316:WHERE
289:Owner
262:Owner
256:ORDER
244:WHERE
223:Owner
169:RDBMS
127:views
87:JSTOR
73:books
884:LIKE
815:cols
812:FROM
749:NULL
665:NULL
503:LIKE
449:FROM
407:NULL
322:LIKE
310:FROM
250:LIKE
238:FROM
150:ANSI
59:news
932:SQL
872:AND
854:AND
824:obj
794:)),
509:AND
491:AND
380:SUM
42:by
1046::
1010:.
893:BY
788:||
776:||
728:||
716:||
710:||
632:||
620:||
614:||
536:BY
398:ON
389:ON
383:OF
331:BY
292:AS
259:BY
226:AS
156:.
129:,
125:,
1020:.
917:;
911:.
908:c
905:,
899:.
896:c
878:.
875:c
866:=
860:.
857:o
848:.
845:o
842:=
836:.
833:c
827:o
821:,
818:c
806:)
800:.
797:c
782:.
779:c
770:,
764:,
761:0
758:,
752:,
746:,
740:.
737:c
734:(
722:.
719:c
704:.
701:c
698:,
692:.
689:c
686:,
683:0
680:,
674:.
671:c
668:,
662:,
656:.
653:c
650:(
644:,
638:,
626:.
623:c
608:.
605:c
602:,
596:,
590:.
587:c
584:(
578:,
572:,
548:;
542:.
539:T
527:.
524:C
521:=
515:.
512:T
497:.
494:C
485:.
482:C
479:=
473:.
470:T
464:C
458:,
455:T
443:.
440:T
437:,
431:.
428:C
425:,
419:.
416:T
413:,
349:;
346:3
343:,
340:2
337:,
334:1
304:,
298:,
271:;
265:,
232:,
109:)
103:(
98:)
94:(
84:ยท
77:ยท
70:ยท
63:ยท
36:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.