Search results for query: *

Denis, the first query is what the application is doing, this is not using the index, so the performance is terrible. I want to create the index on UPPER(exposureid) to improve performance. My question, is this possible? (It is in Oracle).

I left out a significant part, the application is querying the table with: select exposureid, name from anthony where upper(exposurid) = 'TEXT'; I cannot change the application. To improve reponse times, under Oracle, I can create an index of: create index tt on anthony (upper(exposureid))...

I am querying a table using the upper function, the table has an index on the column, but UPPER negates the use of this index. select exposureid from anthony where UPPER(exposure) = 'ANTHONY'; If I issue: create index ex on anthony (UPPER(exposureid)) The error returned is: Server: Msg 170...

Excellent, thanks.

I am studying for the Introduction to Oracle9i: SQL, do you know of any web sites that will help me revise for this? I have completed the literature from Oracle and just need to revise now. Also, what is the pass mark.

Which of these two would be the most efficient, and how do I ascertain this info: delete from riskvarhistory where histjobid in (select histjobid from riskvarhistory INTERSECT select id from histvarjob@my_prim); or DELETE FROM RiskVarHistory WHERE histjobid in (select ID FROM...

Thanks, the command just completed (less than a minute), the other command had been running for over three hours without completing. Yes there are indexes on the permid on both tables. There are no statistics for these queries though, when I look in Enterprise manager, is this the cause of the...

I am excuting the following command on my Oracle server and it has been running for over two hours now (the server is doing 100% CPU): select permid from iinstrumentsectorhist where permid not in (select permid from iinstrumentidmaster); If I do the same command on the same database (but...

I want to create a web page that will allow me to run a BAT file, but this BAT file: 1 - resides on a different server (TR2). 2 - has to run on TR2. Is this possible? From my investigations so far I feel it is possible to execute a BAT file on the IIS server, but remotely???? Thanks

I am looking for reccomendations from people regarding hosting an ASP web site with a MS Access backend. I think I need between 100MB - 250MB of space. Anyone know a good provider that isn't too expensive that can meet my needs, not too much money at the moment.. Thanks

I want to convert a RAW column to an INT? I can convert it to a varchar2 with cast and have tried the following: select cast(cast(reportid as varchar2(20)) as int) from reports; I get the error invalid number.

If you launch sqlplus from dos you have this ability: c:\ sqlplus username/password@instance

Could anyone tell me which table(s) stores the profile infomation. I want to write a query to give me this infomation.

Yeah I tried that, it never redirects to welcome.asp just hangs on the previous asp file. Having a submit button is not really an option. Perhaps I am looking at this from the wrong angle? How do you control the loading of an ASP file?

I have an asp that is checking a username and password and if found redirecting to another asp (welcome.asp). I want to pass some hidden text to welcome.asp so that when it executes it will only show the details for a valid user: welcome.asp reads: <% gre = request.form("h1") if ucase(gre) =...

Thanks, this is only applicable in MS SQL 200 though? I don't seem to find the same thing in my SQL 7.0 analyzer.

How do you do this via the Query analyzer. I know that you can do this in Oracle SQLPlus with the spool command, I also know you can use ISQL/OSQL, but I want to know if it possible to pass the output of my query in query analyzer to a file locally on my HDD.

interestingly if I hardcode all the numbers as 4 and all text as A the update goes through! I suspect the issue lies with request.form, somewhere, I will play further. Thanks.

I have four text fields, ranging from 4 to 50 in size, the rest are number ranging from byte to long interger.

Unfortunately I still get the same message.