Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jetec
  • Order by date
  1. jetec

    How to store FORM data for several pages?

    I also accidently posted this in Jakarta/Tomcat. What would be a recommended approach to storing form data? I have a long form that will require several pages, so I cannot put this all in one page. What would be the most effecient method of store the information from each page? Thanks!
  2. jetec

    Data Source and Java Beans

    Thanks sedj! I did not know I could actually do that, i wasn't sure if it was tomcat specific code. As you can tell, i'm new to jsp/java,tomcat. Thanks! JE
  3. jetec

    Update using Same Table

    I would like to update TABLE_A using TABLE_A. Something like this... UPDATE TABLE_A (FLD_START) = ( SELECT fld_A from tbl_ref where tbl_ref.fieldB = table_a.fieldB from TABLE_A) but i get a "too rows returned" error.. Any ideas or guidance? Thanks JE
  4. jetec

    Copying Data from One Database to Another

    Thanks! I didn't know if there was a quicker method, other than transporting tablespaces.
  5. jetec

    Copying Data from One Database to Another

    I have 180 partitions; not configured for transportable tablespaces. Each partition is huge, (approx 10 million rows) per partition. I am moving this data to another database (same table name, but different tablespaces names). What would be the most efficient way of copying the data over...
  6. jetec

    Tablespaces and Indexes

    Thanks Mufasa!!!
  7. jetec

    Tablespaces and Indexes

    If I do not have striping, should I create a tablespace for INDEX and DATA each? and ensure that these get put on different disks? This is for an OLTP system. Should an INDEX and DATA tablesapce be created for each table?
  8. jetec

    Tablespaces and Indexes

    Is there a rule of thumb on how to create indexes? Should indexes have their own tablespace?
  9. jetec

    Data Source and Java Beans

    how can I utilized a Data source from a java bean? Or do i need to redifine my connection within the class? Thanks JE
  10. jetec

    SQLException e

    Thanks! This is what I needed!
  11. jetec

    Using like and the "_"

    Thanks Mufasa!!!
  12. jetec

    Using like and the "_"

    SQL> SELECT TNAME FROM TAB WHERE TNAME LIKE 'TEST_%'; TNAME ------------------------------ TEST2 TESTA TESTB TESTING123 TESTINGA TESTJE TEST_12_JE TEST_13_JE TEST_PROCESSES TEST_TAB This is pulling all of these..i only want it to pull the following: TEST_12_JE TEST_13_JE TEST_PROCESSES...
  13. jetec

    SQLException e

    Is there a way to interpret exceptions? For example, if I want an ORA-00001 to display a message? if(e=="ORA-00001") { out.println("Constraint violation!"); }
  14. jetec

    Insert Random Data from another table

    Thanks Mufasa!!! This is exactly what I was looking for.
  15. jetec

    Insert Random Data from another table

    How can i insert data randomly from another table? TBL_A ----- ID NAME TBL_A has several records (lets say 10). I want to use the "ID" from this table and insert into another table along with other data. Any ideas? Thank! DECLARE BEGIN FOR i IN 1..200 LOOP INSERT into TBL_B values...
  16. jetec

    Oracle Design Question

    Thanks Mufasa! I'll go with the two tables and generate some data to test out performance.
  17. jetec

    Oracle Design Question

    I have a checklist form that has 44 questions? A simple 1 or 0 is collected. My question is, should I create a wide table with 44 fields, plus an additional two fields that identify the user and form, or should I have a "user/form" table and then a "detailed" table with a "user/form" key that...

Part and Inventory Search

Back
Top