Sitemap

Amicuk Programming Answers

Need to find total no fo  tables/index/m.views in my database

2015-10-11   Views:0

Advertisement

Hello Everyone ; How can i find total no fo  tables/index/m.views in my database ? when i  google  i have seen  following  command ; SQL> Select count(1) from user_tables where table_name not like '%$%' /   COUNT(1)          but i dont understand  wh

Hello Everyone ;
How can i find total no fo  tables/index/m.views in my database ?
when i  google  i have seen  following  command ;
SQL> Select count(1) from user_tables where table_name not like '%$%' /
  COUNT(1)
         but i dont understand  what  '%$%'  indicates ?
Thanks all ;

The replay answer
Advertisement
Hello Everyone ;
How can i find total no fo  tables/index/m.views in my database ?
when i  google  i have seen  following  command ;
SQL> Select count(1) from user_tables where table_name not like '%$%' /
  COUNT(1)
         but i dont understand  what  '%$%'  indicates ?
Thanks all ;
consider to simply Read The Fine Manual YOURSELF!
Oracle Database Search Results: like

Go to See the other 9 answers

Need to find total no fo  tables/index/m.views in my database

Category:DefaultRelease time:2015-10-11Views:130

Hello Everyone ; How can i find total no fo  tables/index/m.views in my database ? when i  google  i have seen  following  command ; SQL> Select count(1) from user_tables where table_name not like '%$%' /   COUNT(1)          but i dont understand  wh[More]

Table index naming conventions in AW2008

Category:DefaultRelease time:-0001-11-30Views:130

In looking at the various table indexes in the AdventureWorks2008 sample database, I noticed that all the index names are prefixed with either "PK_", "FK_", "AK_", or "IX_".  I know that the initials for the first t[More]

DB02old  showing Missing in R/3 DDIC Tables & Indexes in BI 7.0 system

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Db02old showing missing in R/3 DDIC Tables & Indexes ,Details given below.                                     Tables          Indexes Total number                        63,413          88,532 Total size/kb                1,208,272,704     227,4[More]

Linkage between TOTAL & VIM_TOTAL_STRUC in Table Maintenance Fun.Grp

Category:DefaultRelease time:-0001-11-30Views:130

All, I have the following code in one of my custom Table Mainteance Function group. Here My question is Updating the  with <vim_total_struc> = ls_wa. get updated in Total. I could not figure out how  linked to total LOOP AT total.   CHECK <action[More]

How to obtain the table index in word use LabVIEW Report Generation Toolkit for Microsoft Office

Category:DefaultRelease time:2015-10-11Views:130

I created a word templete and it had several tables. When I use the "Word Edit Cell" function in LabVIEW Report Generation Toolkit for Microsoft Office, the function need "table index", and I didn't find any function to get or set the[More]

To Use  Cursor or  TYPE table Index by PLS_integer

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Let's see if I have table with no. of records 19,26,20,000. If I want to loop through all the records which will be a optimized way To Use Cursor or TYPE table Index by PLS_integer. Please guide. Thanks.What is it you want to do to/with the r[More]

Fact Table index vs BIA Index

Category:DefaultRelease time:2015-10-11Views:130

BIA gurus.. Prior to our BIA implementation we had the drop and rebuild index process variants in our process chains. Now after the BIA implementation we have the BIA index roll-up process variant included in the process chain. Is it still required t[More]

Adding Sum Totals from Multiple Tables in A single Document

Category:DefaultRelease time:2015-10-11Views:130

Hello All, I'm having trouble adding sum totals from multiple tables I've created in a Pages 09 doc. I putting together a spreadsheet for cost projections for a house remodel. I created tables for each room of the house. At the bottom of the document[More]

New tables & indexes created do not show up in dba_segments view

Category:DefaultRelease time:2015-10-11Views:130

Dear all, I have created 3 tables and some indexes, but these objects do not show up in dba_segments view. Is this a normal behaviour? Previously, with dictionary managed tablespace, I can specify the minimum extent to create, when the table/index is[More]

INDEX on VIEW or TABLE when using CONTAINS function on the VIEW

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm querying a view with a contains function and I'm getting an error: query: select * from view where contains(name,'jack OR jill')>0 ORA-20000: Oracle text error DRG-10599 column is not indexed. From what I gathered you can't create an index on[More]

BWA Fact Table Index Size

Category:DefaultRelease time:2015-10-11Views:130

Hi Can anybody tell me how the BWA decides when a fact table index gets split into multiple parts? We have a number of very large cubes that are indexed and some have a fact table index that consists of one logical index which is made up of multiple[More]

Hot
Dear All,         We have converted a alv grid into pdf and sent a mail with the attached pdf file. When the attachment is opened in the received mail we get an error " File does not begin with %pdf-". I am pasting the code. Select single   from [More]
After reading so much advice on this forum, I just wanted to tell you guys about the problem I was having with getting my Windows XP machine and iTunes to communicate with my brand new 80 Gb iPod Classic, and how I finally managed to fix the problem [More]
Please Help, I can't figure this stuff out! I've just built my second website and the code for clickable thumbnails for my image gallery doesn't work in Safari, unless I refresh the page. For some reason, a mouseover on a thumbnails fails to call the [More]
I created a multi page document and exported it to a SWF file. The pages show and play but only if I tell it to go "Forward". Is there a way to play all the pages? Thanks, PeterI've solved the problem in a round-about way. I re-did the SWF files [More]
Hi Experts, We are working in demo systems with GRC AC 5.3_10.1. We are trying to create a single role in ERM. When trying to add Function ID PR01 or PR91, it is throwing error as "unknown error occurred while performing operation (Cannot assign a ja [More]
When I launch Aperture, it initializes by showing "opening Aperture library" but after a few seconds it stops and does not open the program.  How do I launch Aperture?  It worked before, not anymore.  I've downloaded latest updates, but still ha [More]
I have a user who recently updated her OS to Mavericks.  Now whenever she tries to upload a Keynote presentation to iTunes U she gets the following error message.   Help??Thanks for your help Jim I found some info in other threads and read that some [More]
I just uploaded some revised pages to my site. When I went to view them online, the older pages displayed instead of the new ones - since the older ones were in my browser cache (same thing happens in both I.E. and Firefox).  Going into I.E.'s Tools [More]
I downloaded and installed the latest iPad software and my iMac will now not boot up. The iMac was getting a little slow just prior. Is one year old and this is the first problem. I have put the system DVD in and rolled back a couple weeks. Still no [More]
I switched my Verizon portal partner from Yahoo to Windows Live w/o any problems.  At the Windows Live sign in page, I can sign in with my @verizon.net email address.  The problem is with a sub-account I manage.  At the Windows Live sign in page my s [More]