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
I would dearly love to install the latest Quicktime, to view multimedia products on my Britannica encylopedia, but halfway through 2 windows pop up as follows: Quicktime error message Error - 1316; a network error occured while attempting to read fro [More]
Dear All, We have a SharePoint/Project Server 2013 Enterprise Edition and Sharepoint Designer deployment in HYPER V virtual environment. We are using it for Project Management. We are facing an issue while designing a workflows in SharePoint designer [More]
Hi, I am using OJMS with OC4J 10.1.2 and db 9.2.0.5. I have a web application which send messages into the queue very frequently. But the problem is the MDBs stop listening to the queues after some time (1-2 days) and no more messages will be dequeue [More]
Hey guys, So I have a 1 Tb Lacie harddrive that has 3 partitions. 1 small one for windows transfers, 1 mac formatted disk and 1 dedicated to Time Machine. I back up everything except the Movies and Downloads folders. I have a new imac at my disposal [More]
I tried to play a song that I had downloaded on another computer. It said something like I needed to 'authorize' this computer to play that track. I tried to authorize it and got a message that I've run out of accounts and need to 'de-authorize' a co [More]
Can I development program with EDK for uploading file to server?How to avoid same name of files? Thanks!Hi , thanks for the quick response. but the problem is supppose i have a excel sheet with 16 rows and 13 columns(so data). i am placing this file [More]
Every time I click to open something in a new tab, it opens in a new window instead. I checked to see if I'd accidentally changed my options to make things open in new windows instead of tabs, but I hadn't. Also, every time I start Firefox, three win [More]
I hv instaI hv installed the adobe CS6 collection last year, and i used up 3 quotas of installing as my mlled the adobCS6 collection last year, and i used up 3 quotas of installing as my mac book clean installed few times by apple, because of the cra [More]
Dear Freinds, We did Field Exit changes in Developement system and the changes are working perfect when we tested. Where as we transport the changes to QA(Quality system) the filed exit is not working. We checked the code, and the code was moved to Q [More]
Hi all, 1) Can any one send the download link for oracle forms9i and reports9i developer? 2)I am using Oracle 9i database. Is oracle forms10g support for Oracle 9i database. Thanks and regards MichaelIf it's available, it'll be on either http://downl [More]