[Cross-Posting from ServerFault] I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnect
I have a table that is 5 GB, now I was trying to delete like below: deletefrom tablename where to_char(screatetime,\'yyyy-mm-dd\') <\'2009-06-01\'
I have a table with fields (simplified): id, fld1, fld2, fld3. id is a numeric primary key field. There are duplicates: id differs but fld1, fld2 and fld3 are identical over 2 or more rows. There
I have a table that stores the page hits on a web application, storing unique_row_idhttp_session_idpage_namepage_hit_timestamp
I have a table named testtransaction开发者_如何学编程 which stores pervQuestionId and NextQuestionId...
I have one table : Questionmaster. it stores DisciplineId,QuestionId,QuestionText etc... Now My Question is:
I\'ve some prob with the function TABLE in ORACLE. SET SERVEROUTPUT ON SIZE 100000; DECLARE int_position NUMBER(20);
I\'m pretty sure this is something really silly. Instead of spending another 10 minutes with this ( or better said, while I spend another 10 minutes with this )I\'ll ask it here in parallel.
I bind a SQLDataSource to a GridView using GridView.DataBind() and these queries often take a significant time to execute.
Advice/suggestions needed for a bit of application design. I have an application which uses 2 tables, one is a staging table, which many separate processes write to, once a \'group\' of processes has
加载中,请稍侯......