Nige Ridd

If the table has been modified recently and is 10g, you can try select scn_to_timestamp(max(ora_rowscn)) from test; Think I've seen things say it's only up to 5 days you can use this. If you need to and can modify the database, you could always create your own version of the …

You could try something like [code=sql]select date1 + rownum from all_objects where rownum < date2 - date1;[/code] Nige

In SQL Server Management Studio, connect to your server. Then right mouse click on the Server in on Object Explorer window and select Properties. This should show a new dialog, and a 'Select a page' panel on the left - choose Security and the you should see the settings to …

You could use [CODE]select Column2 from table1 t where Column1 = ( select min ( Column1 ) from table1 ta where ta.Column1 > [I]NumberRequired[/I]);[/CODE] Nige

You could always write some PL/SQL which adds a trigger to each table, as the table gets changed you could produce some sort of log. Nige

Wouldn't be much better and much more maintainable if you converted the values to a date datatype? Nige

Not sure triggers are the best way to do this. BUT if you want to stick with triggers, you'll also have to write update and delete triggers ( If you delete an order for an item it's availability would increase, updating an order could affect it either way ). Nige

The cache size is how many Oracle will cache in memory, so when you first select a next value it will read the sequence from disk (n), and write back a next value of n+20. Then as you keep getting a next value it will just give you the next …

Or even look in the Help menu in JDeveloper itself - the 'Tutorials on OTN' might be worth a look at, but I'm sure they've already tried that! Nige

Have a look at [url]http://www.a1vbcode.com/snippet-3876.asp[/url], it's not my code so i can't validate if it works, but best just to try it. Nige

You can always try XSQL, which allows you to use SQL to generate XML and then apply XSL to produce a web page. But it's probably easier to use something like PHP instead. Nige

Oracle have J Developer and SQL Developer, both free from their web site. If you develop more PL/SQL I'd go for J Developer as it's more aimed at a project style development, where as SQL Developer is more around working with SQL scripts. Nige

Not the best solution but... [code=sql]SELECT * FROM EMPLOYEE WHERE EMPLOYEEID IN ( SELECT EMPLOYEEID FROM ABSENCEHISTORY GROUP BY EMPLOYEEID HAVING count(*) = ALL(SELECT count(*) FROM ABSENCEHISTORY GROUP BY EMPLOYEEID))[/code] You should take into account that there may be more than one person with the worst attendance. Nige

The ALL_ views, list all objects for a particular type across all schemas in the database. The USER_ views list those of just the user that is logged in. As you can imagine - the ALL_ views ( in some databases ) will contain much larger volumes of data than …

The reason why your not getting any data back is that your query is effectively looking for customers who are both business and home customers at the same time. You'll have to use outer joins to allow you to retrieve one or the other. Nigel

You can't use Windows security, you'll have to hardcode the user name and password somewhere. Nige

If your doing the connection pooling at the client end then I'd have thought you'd know how many connections your using. There are quite a few caching algorithms for various systems around. Depends on what language or in Java - which j2ee engine your using. Nige

Your question is a bit vague, can you provide more details and then people may be able to help. Nige

Is the category just an additional record in a table - if so why not just write a Coldfusion page to do it. You can go into the CF Admin web site and look at it from there, thats assuming the old admin left the password with someone. Nige

Erm can I make a suggestion that you look at using cfqueryparam as well, if anyone ever put a ' in any of the fields on the screen they can then do some nasty SQL injection into your code. Nige ( See many references on the web about SQL Injection …

An alternative which you may see commonly is instead of using multiple references to a field with 'or' is to write something like Select * from RG_TAB where CMCode in ( 4, 5 ) You can imagine when you have 5 or 6 possible values that this is much shorter …

I've been using SQL Developer ( and JDeveloper ) from Oracle themselves. It's a free download from their site. Nige ( [url]http://www.oracle.com/technology/software/products/sql/index.html[/url] for download )

The value of a check box can be set using something like <cfinput type="checkbox" name="SelectedDepts" value="4"> BUT this value will only be returned if the user checks the box, so either do an isDefined or use cfparam to default it to something. One thing you should consider as well is …

You would have to use client side cookies to store their identity to be able to pick this up on subsequent logins, so why not store the configuration entirely using cookies on the users machine? Nige

It's easier to BS and try and confuse someone else than actually sit back and listen to what a customer wants and deliver it. The only thing I would say though is that sometimes the client has to be guided - and by this I don't mean told what to …

Your intermediate table ONLY needs to contain the member and training class. You could include extra data if you wanted ( and if applicable ) like Dates of when the person applied/paid for the course, completion of the course, perhaps even their feedback on the course itself. Nige

Sorry - not sure of the point of this post. Also not sure what you mean by 'Data Management Software', not a term I'm used to. Nige

To be honest, it's actually quite difficult to read the code. Try and break it down into logical segments ( i.e. retrieving data, extracting data, update data ) and it may be easier to track whats done where. One thing I've asked people to try before is to use <cflog> …

I'm fairly new to GUI coding, but what I would have done is to separate out the routine that populates the table, passing into it the sort order as a parameter. Then when the user asks the data to be resorted, you can simply call this routine with the sort …

Think you need to replace your select from select count(i.column_name) into cnt from test; to execute immediate 'select count(1) from test where ' || i.column_name || ' is not null' into cnt; This is needed because you can't dynamically pick which column you want to include in a SQL statement …

As I also use Oracle PL/SQL I've tended to use JDeveloper which is free from Oracle ( always a help ). Nige

I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige

Sorry if this is the wrong group to post in - I couldn't think of another suitable one. I'm applying for a job which talks about 'experience using Java/J2EE', I've used Java but not sure if by putting J2EE that they are expecting anything particular? Thanks Nige

My Coldfusion isn't the best - but it would probably be better to convert the GetOutOfOffice.cfm to a cfc which just has a function to return the display content as a string instead. Alternatively you could test for having [peopleoutofoffice] in your text, then output everything up to that point …

One thing you need to think about is do you actually need to store a row per hit of the web-site? Could you just not have a small table which counts the hits per site? If you do need each hit - you could hold each hit in a log …

Don't you just need to group on expirationtime? Something like select expirationtime, count(expirationtime) from messages group by expirationtime; This will give you a list of the distinct expirationtime and the amount of times they occur. Of course you'd have to replace the expirationtime in the above statement with your calculation …

You should get rid of the * after the delete. Also I'm only having a guess here as I can't try it. But is it worth renaming the table 'SUM' to something else as in some systems 'SUM' is a reserved word in SQL.

That can be solved using SQL, which is always preferable to use rather than PL/SQL if you can. The following would give you the results, there may be better solutions but as it's not too horrendous I thought it should be OK. select custid, custname, custnumber from testtable where mod(custnumber, …