Recent content by lhugh

Good point. Another way to do it is to create a class for the sample table public class Sample { private int field1; private string field2; some getter and setter } * Create an array, list of the type Sample * iterate through your object with a while loop and while (object.hasnext() )...

why can't you write a sql statement like this SELECT * FROM sampe WHERE name IN (SELECT DISTINCT(name) FROM sample)

How can you get to the file from SQLPLUS sqlplus > $ <enter> c:\cat filename when you are done viewing c:\exit sqlplus>

Greg, you do all the work in the command prompt in windows or unix/linux c:>sqlplus/nolog sqlplus> connect sys as sysdba password: <enter password > sqlplus> {do your work here}

if somebody deleted some records by mistake, is it possible for me to retreive the data using flashback query. If yes, how do i do that?

thanks Dave

Is there a view to find out what jobs are scheduled in an Oracle database? And how do I turn off a job(s)? I think there is a DBMS package but I forgot which one it is Thanks

if my oracle server has a private IP address and so does my oracle client, how do I set up those two computer so that the client can see the server? what is the easiest way to achieve this? This is only a test environment and has no sensitive data

I totally agree with Dave that it's best to use the same version. I do not think that a backup from 9i will work with 9i Here is my question, if we are to re-create a database on 9i, re-use the controlfile and datafiles from the 8i database, what will happen? We can change the compatibility in...

The application that we use mostly is SQLPlus All my team members do not change their passwords. I want to force them to change it Thanks

thank you Dave. You are THE man :)

I was asked at work for the difference between an Oracle8i database and an Oracle9i database I am not sure how to answer this question, any suggestions?

How do I force my user to change his/her password when the user login?

I am sorry I didn't understand where DBA studio comes from? How do I find it? I also would love to know more about statpacks so please post anything that you find helpful thanks

thank you.