Search results for query: *

...In the detail section. Its been awhile, can anyone assist.

Thanks Madwac for the info. Very much appreciated.

Fellow Professionals, I am using Crystal v.11. I've lost all knowledge with Crystal and now I'm just getting back to it again due to a new job. Here's my question... I need to do display multiple counts on my report dependent upon certain conditions. ie. my data is as follows in the detail...

Fellow Professionals. Any workaround avaiable for loading a 255 character string via SQLLoader. Please advise.

Hi. Currently with our external programs whether it be a batch program or user interface, we are using the ops$ authentication as well as explicity hardcoding the data source, userid, and password. Our clients are somewhat getting concerned since our hardcoded user/pasword methodology will be...

Mufasa....This is great. Thank you. On my original query, it seemed as if I was still doing a full table scan per the Explain Plan. It is my understanding that a full table scan will not utilize the appropriate indexes. Am I correct? This is the reason why I needed any other .sql...

Fellows...Any other way I can rewrite this outer join query. select a.id from app a, account b where a.id = b.id(+)

Thanks Carp...I realized this after I had posted the question. Thanks Anyway.

Fellows, I have a character field with value of 02/10/2005. I need to convert this to a date with a DD-MON-YYYY format(10-FEB-05). I hate dates..any assistance would be appreciated.

Mufasa and Carp. I merely want to thank you greatly for your efforts in providing this solution. Yes, it is a 'freebee', Thus, I am even more THANKFUL for taking the time to tend to this thread. It is no surprise why both of you are highly regarded in the Tek-Tips forum. And Carp...to you...

Understood again..Thanks Mufasa.

Thanks so much, Mufasa.

Mufasa...here's a question...how do you know a machine's block size? (sorry for the dumb question)

Carp...can you clarify my results below. Before a REORG, my application and works table reported.. Table Current Est. Est. Space Chained Name...

Carp..Understood. Update!! ...as I continue to run "swiss_cheese.REORG", the assestment report is getting smaller and smaller. In some cases the same tables are still being reported but with smaller values for 'Est Savings'...(which is good, i guess). Question is...how often should I run this...

Mufasa...I know it makes it all confusing since I am a newbee, but NO, the assessement factor has not changed and the tables are all from the same schema. Another question...how high is high in regards to 'Est Savings' value...are we saying that the hundreds are high. I have tables reporting...

engineer...no data has been inserted. I am actually testing on a development server which has no activity. Thanks for your response.

Carp/Mufasa...what I am noticing now is this. After I have executed the "exec swiss_cheese.REORG" displayed from the assestment query(from swiss_tables), and then running the 'exec swiss_cheese.assess_schema' to verify the changes, the output list addtional tables that were not initially output...

CARP AND MUFASA. Thanks for the clarification. It's making more sense now. I will continue looking into this until it makes 100% sense to me. You both have been great.

Mufasa..I just read your response. I am quite confused now. BEFORE REORG... Table Current Est. Est. Space Chained Name Blocks Blocks Savings Used Rows ------------------------- ----------...