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 created an SVG in Adobe Illustrator CC with all the recommended settings (yes, I unchecked "Responsive"), and then placed it in my website in Muse CC, and it does not appear on my website.  It just shows a broken photo link icon where the imag [More]
I have a page with NO comments that output unicode in xml and sometimes it works, sometimes it says: Incorrect syntax was used in a comment. Error processing resource ' http://www.netspeaknow.com/gamers/flashCFM/getPopQuiz.cf... <!-- " --->< [More]
Trying to follow online help but it doesn't relate to DWCC.   A tutorial I found for CS6 suggests that it's in Insert > Data Objects > Update Record > Record Update Form Wizard but in DWCC there is no "Data Objects" option in the Insert [More]
Hi All, In the workarea of an internal table i have fetched address (PA0006-STRAS). This address may contain ',' or ' " ' . I would require the address to be moved to the final table without ' " ' and ','. eg:169 6 cross street, 35 - Ed. "E [More]
my hard is about to full, and just 1.4 GB free, during use of some soft ware, it restarted , and never start up again, what can i do for it? how can i backup my file?Startup Issues - Resolve Startup Issues - Resolve (2) Startup Issues - Resolve (3)Re [More]
Apple id lost. Cannot get Access to it. Started with a mail from apple id saying that apple id and password were changed. Did not sent such a request myself. Since then no acces to apple id, not even via forgot my id site. It says that my apple id an [More]
Hi All, Please let me know if you know fndload command to download concurrent program without value set definition. Thanks, Viaswas Edited by: 873477 on Mar 8, 2012 1:55 AMI agree with Sandeep -- The only option is editing the ldt file after the down [More]
hi All, I'm facing the same issue, I have a soap request which will update the metadata field on the service call. The request url is coded as var requestUrl = httpCgiPath + "?IdcService=UPDATE_DOCINFO" + "&dID=" + datafileID +&quo [More]
I just bought a new wi-fi iPad 3 after my previous iPad was stolen. I use my iPad to do a lot of sensitive work. When my previous iPad was stolen I reset all of my passwords and disconnected all of my 3rd party apps from that device. This was far mor [More]
I recently succeeded in not only getting my external hard drive to work correctly with APE but I have also been able to allow computers to access the hard drive when not within the network. The only problem is that the only computers which can use th [More]