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
Hi there! Earlier I had CS 2 installed on my iMac, but problem occured and it got messy and I uninstalled in hope of being able to reinstall again. followed the uninstall guide that comes with the bundle, but i can't reinstall anyway. The guide tells [More]
I'd like to use the freeform drawing tool to mark up PDFs on my tablet, but I'm having a problem with drawing accuracy. For some reason Acrobat takes a split second to recognize that the user is drawing after putting the pen down. For example, rapidl [More]
Hi guys I am using these two reports with same selection criteria. S_ALR_87012326 S_ALR_87012328 But report S_ALR_87012326 is showing Less G/L Account whilr report S_ALR_87012328 show many G/L Accounts for a same company. Can anyone tell me whats the [More]
Hi, I am trying to load the data through flat file, for 0calmonth column I gave the values in the format year/month and month/year, but when I am trying to view the preview it is diplaying the following error CONVERSION_EXIT_PERI6_INPUT. which format [More]
i want delivery and billing no i.e vbeln and quantity for billing and delivery for category 'J' and 'M'   for corresponding sale order Nothing is displayed while executing only the heading is displayed but in the debugger got the values for all how t [More]
as OutputStream or Writer has already been obtained. Getting this error. Using Jdk1.3.1_01 with Tomcat. This did NOT happen in JavaWebServer2.0 (30 day demo version). This is the part of the code that is giving me the problems. RequestDispatcher show [More]
I downloaded/installed adobe reader on imac. Using safari, I cant open a PDF. It says: Launch adobe reader, accept end user agreement, quit and relaunch. How do I do this?What is your OS X, Safari Version and Adobe Reader Verison? Please try this: Qu [More]
Hello All, My intention is to load Cost center hierarchy into MDG system and i am following SAP Note: 1573223. According to SAP Note, While uploading the hierarchy data, it is asking us to select the CR, which was already created. My question here is [More]
This apple post : http://support.apple.com/kb/HT3920 says they will not support Win7 on older Mac Pro's (e.g. 2.66ghz dual). Does anyone know why? When I try to instal Win7 on Bootcamp 3 I get a BSOD and it will not run. Suggestions?If you look close [More]
I have a new Q10 which does not seem able to sync my outlook calendar from my PC. Duplicate entries appear on the phone (blue and green) and often diary entries that I have deleted on the PC and phone reappear. What can I do? Thanks in advance if you [More]