Search results for query: *

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...

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...

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.

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

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) =...

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.

Getting the following error message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. How do I investigate this, I can't work out the line that is causing the problem?

Using the set command in 2000 DOS session only changes the system environment variable for that instance, i.e. set RP_EXEGROUP=ANTHONY. Is there a way, other than importing the infomation into the registry (regedit -s file.reg), to change the system environment setting in a 2000 DOS session.

I have the line: response.write &quot;<TD><a href=History.asp?Details=&quot; & objRS(Wcount) & &quot;>History</a></TD>&quot; Where objRS(wCount) has the value of &quot;ABS CMO Ratings&quot;. When I hover the mouse pointer the link Details=ABS . The rest of the string is truncated, any ideas why?

select count(distinct exposureid) from iinstrumentidmaster where exposureid in (select exposureid from iinstrumentidmaster group by exposureid having count(exposureid) >1) order by exposureid Can't work out why! MS SQL is not my speciality.

I successfully shutdown Oracle on Friday night, shutdown immediate. The Box was powered off Friday night and powered back on Monday morning. This morning I started the listner and then sqlplus /nolog, connected as SYSDBA and tried startup, received the following: ORA-27302: failure occurred at...

I am loading a huge amount of data into three tables and currently the scripts drop the indexes on these tables (one is unique), loads the data and then recreates the indexes. Would it be more effective to load the data and then rebuild the indexes?

I want to execute a external SQL script, i.e. @sript.sql, dependent on the answer to my accept prompt, which I am determining by decode. accept xanother promt 'Again, Yes/No: ' select decode (&xanother, 'YES',@script) from dual Is this the best way? If so, what's wrong with it?

Are you able to EXP a database from Oracle 9I and IMP it into Oracle 8I?

I have a table over 1 million rows, each row has a unique ID and a country code assigned. There 107 country codes, I want to write a query that retruns the 107 country codes and A corresponding ID

I want to write a script that will do the following: 1 - select colum from table where condition = &quot;R&quot; Then I want wrap this statement around the condition that if the outcome of the above is 0 rows then: select message from messages where id = 1 I am struggling with Oracle, I...