Don't know of any view, but to not alter the database you could get the last SCN and for each table output whats changed since then.
You can use:
SELECT current_scn, SYSTIMESTAMP FROM gv$database;...

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

You could always have Googled and found something like
http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_sps.html

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

Not sure what you mean by that? Wouldn't have thought the content would have affected it.

Nige

Wouldn't be much better and much more maintainable if you converted the values to a date datatype?
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...

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

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

Sorry - I thought this person wanted to create Oracle users, this isn't a case of adding a record to a table, it's more a case of executing various DDL statements to create the user, assign default...

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

You could use
select Column2
from table1 t
where Column1 = ( select min ( Column1 )
from table1 ta
where ta.Column1 > NumberRequired);
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...

Unfortunately Select top n isn't supported by Oracle.
Nige

If you follow your arguments - then why not use sql plus for PL/SQL development, after all you don't need an IDE to do PL/SQL programming! Just that people prefer to have one system to do most of...

Not the best solution but...

SELECT * FROM EMPLOYEE
WHERE EMPLOYEEID IN (
SELECT EMPLOYEEID FROM ABSENCEHISTORY GROUP BY EMPLOYEEID HAVING count(*) = ALL(SELECT count(*) FROM ABSENCEHISTORY...

I was more referring to working with a project, which if your doing any reasonable level of PL/SQL then your more likely working with multiple files and some form of version control system for...

How are you trying to run it? If you are using strings for the values of date1 & date2 then you'll have to put to_date() round each one as it uses the date arithmetic features in Oracle.
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...

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

You could try something like

select date1 + rownum
from all_objects
where rownum < date2 - date1;

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

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

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

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

You can't use Windows security, you'll have to hardcode the user name and password somewhere.
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
(...

I've been using SQL Developer ( and JDeveloper ) from Oracle themselves. It's a free download from their site.

Nige
( http://www.oracle.com/technology/software/products/sql/index.html for...

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

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

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

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

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

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

I'd be interested to know how much people use the features of their development environment to do the work for them and how much they prefer doing all the leg work themselves.
This relates to...

As I also use Oracle PL/SQL I've tended to use JDeveloper which is free from Oracle ( always a help ).
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...

Your right - but it doesn't mean that I can't learn the concepts fairly quickly. Sometimes learning a new technology may sound more daunting than it actually is.
Also you have to take into account...