I have a select statement which makes use of analytic
functions. If i execute this query the response time
is 20ms. However if i apply an outer Select to this
Result set the response time is 6 minutes.
My inner subquery is as below .
This executes in 20 milliseconds.
ResultSet=
SELECT '2' AS...
Thanks very much for giving your valuable time into
looking at the Query.
The following are the ERROR Stack Messages
ORA-12801: error signaled in parallel query server P014
ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at "ORACLE PACKAGE NAME.STORED...
Hi,
Oracle Version : 8.1.7.0
I am executing a PL/SQL package which has a query
having Union of Two Select Queries.
One of the Select queries has a To_DATE(Null) in it.
The Query when run seperately outside the package works
fine but within the Package it fails.
Strangely for the same...
Altavista (Visitor) Nov 23, 2000
I am doing a online shoping system. in that,
When user clicks SEARCH Option, i am retriving data in a loop from Database until Recordset.eof, i am displaying some details using table. Normally i am displaying more than 20 records at a time.
1) I need to...
I am doing a online shoping system. in that,
When user clicks SEARCH Option, i am retriving data in a loop from Database until Recordset.eof, i am displaying some details using table. Normally i am displaying more than 20 records at a time.
1) I need to display only five records in a page, and...
on the mouse over event of a link i should get displayed another two links below the original one. and move the mouse from the original link the displayed (sub links) should disappear.
Regards,
Murugesan
I am online shoping system in ASP and backend is MS Access. In a page i am executing More than one SQL. if any one SQL aborts, Other Sql Should not COMMIT.
Regards,
Murugesan
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.