Search results for query: *

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?

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

and how do I shut down the job that I do not want to run? Thank you all

I would like to alter a column name of my table. Is it possible to do it?

I got this error Generated servlet error: [javac] Compiling 1 source file C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\khoa\org\apache\jsp\MainOracleConnection_jsp.java:62: package oracle.jdbc.driver does not exist DriverManager.registerDriver(new...

does anybody have an example for this problem: retreiving data from an XML file into a JavaBean? I want to: ** Extract data from XML file ** Temporary store data into a bean ** Insert (bean) into MySQL database thanks

I need to run a batch file (test.bat) in c:\windows\test.bat I would like to create a Java application to run my above batch file. Is it possible?

Is it possible to do that? For example can I create an XML file from the below select statement? SELECT firstname, lastname FROM employee

which function can I use to select the date in order to return date in this format YYYY-MMM-DD Thanks

Why curdate() does not work for my query? I would like to to find all softwares that are going to expire within the next 60 days. The query should have returned 3 rows, not 2. Here is the list of all records in my table: mysql> select title, expiry_date from license...

how do I change the default report location when you run spreport.sql? What is the default location and how do I change it? for some reason my reports are being saves to C:\ directory Thank you

Does anybody know what this means? Thanks ---------------------------------------- SQL> variable snap number; SQL> begin 2 :snap := statspack.snap; 3 end; 4 / begin * ERROR at line 1: ORA-01654: unable to extend index PERFSTAT.STATS$SYSSTAT_PK by 256 in tablespace TOOLS ORA-06512...

does anybody know where I can find a tutorial on creating trigger in MySQL I have a fied called expiry_date, I want to create a trigger on this field and that if the current date is a month prior to expiry date, my database will send an email to remind the system admin to do something. Where...

my XML has Year: Weight: Price: I would like to diplay all records with Year > 1980, Weight < 50 lbs and price < 5.00 How do I express this in XSL Thanks

I need to reset some of my parameters. My database is using an SPFILE right now. I am thinking bout creating a pfile from spfile, edit the pfile and re-create the spfile I am able to create the pfile but I can't create the spfile. Oracle gives me an error saying that there is an spfile already...

I would like to list all the table that belong to John Doe a regular user in my database. How do I do that in DB2? Thanks

does anybody know DB2 JDBC connectivities? i found a few sample codes on the net but i couldn't get anything to work