Search results for query: *

I have so much queries similar to select t1.c1,t1.c2,..., t2.c1,..., procedure_very_big(t1.c1,t4,c2) ,t4.c4 from t1 ,t2, t3, t4 where ...; rrrrr data rrrrrrr rrrrr data rrrrrr rrrrr data rrrrrr 3 rows selected The execution takes several minutes,even hours. And my question is Is...

Hi Im using Oracle 7.3.4.5 over a Compaq Digital V4.0 D (878). Im getting more and more errors in the alert file. They are produced at night, just whe the cron is trying to shutdown the database after a full consistent export. For shutting down the DB, i use a changed version of oracle dbshut...

Im new in MS SqlServer , im using version 7. Its posible to have at the same time FK, and cascade update. I have created a FK between a parent and a child table, and i also created a triger update in the parent table in order to transmit any update of the parent to the child. But it doesnt...

Hi Im new in Oracle World and even more new in MS Sql-Server 7.0 . I want SQLServer not to check the validity of a constraint until the transaction is committed. it is veruy useful for DML sentences against related tables when you can not guarantee the order of the SQL-sentences inside the...

What i get is something like: select round(1.5),round(1.49999),round(1.5000001) from dual; ROUND(1.5) ROUND(1.49999) ROUND(1.5000001) ---------- -------------- ---------------- 2 1 2 What I need is something like: select...

I have a table with "TEAMS" and "POSITIONS_IN_A_RACE" Example TEAM POSITION ---- -------- A 1 B 2 A 3 F 4 A 5 C 6 A 7 B 8 B 9 ... ... I want to create a clasification, I must take the three best positions of each team: Example...

I Use Microsoft SQL Server ODBC Driver Version 03.70.0690 I have defined some correct ODBC connections and they seem to be well defined, the test data source give me "TESTS COMPLETED SUCCESSFULLY!" but when I try it to use those "user data source" from differents...