Recent content by jestrada101

okay.. i wasn't aware that those db's could run on Mainframes... i was assuming they were all terminal screens..

I'm not familiar with mainframes, so i'm trying to get feedback with someone who has talked directly to a mf. pulling records, etc from it.. is this what you want? have you don this?

True... thanks for your feedback Sheco!

Can anyone give me any feedback on prior experience with you all doing this? Performance, stability, etc? Thanks! JE

How would you rate the performance? Thanks JE

has anyone worked with getting ASP to talk to a mainframe? if so, could you point me to good documentation. Thanks! JE

Thanks.. I found this online: To return the last name of the full name in A2, use the following formula. =LEFT(A2,IF(ISERROR(FIND(",",A2,1)),LEN(A2),FIND(",",A2,1)-1)) To return the first name of the full name in A2, use the following formula...

How can I split the following into separate columns? COLUMN A ----------- DOE, JOHN A DOE, JANE I'd like it like this COLUMN B COLUMN C COLUMN D -------- -------- ------ DOE JOHN A DOE JANE I've been using this for the firstname...

A couple questions: 1) Any got a huge warehouse (365 days with approx 8 million records per day) that have some GUI record retrieval built around it? 2) Is there a method to retrieve records from a binary file loaded into database, if so, is there a way to do even a query into that file...

this is put into a loop that gathers stats against partitions... dbms_stats.gather_table_stats( ownname => 'ABC', tabname => 'TABLEA', partname => prtn_rec.partition_name, estimate_percent => 0.1, block_sample => TRUE, cascade => TRUE); Any idea why it...

My archive log is stuck, it ran out of space. How can I cancel the archive log and disable archive adn bring the db back up? Thanks! JE

I have RMAN failing on 10g on doing an archive. Archive log is on, how can i disable this. Thanks for any help.

If a system is part of an ORACLE RAC configuration, is it possible to add another instance to that same box?

How can i get sets of duplicate data? For example, I have the following data in a table. 12312 DATA1 DATA2 12323 DATA1 DATA2 33333 DATA3 DATA1 42324 DATA3 DATA1 I'd like to return the matching: 12312 12323 33333 42324 How can I get this in query?

Thanks Commit=Y worked!