Hello,
We have recently added a Windows 7 64 bit machine to our network. Periodically the machine loses its internet connection as well as any external db connections. When this happens the machine still says it is connected to the network with "Internet access". Also, I am still able to RDC...
Hello, I am wondering if it is possible to call a stored procedure from a select statement?
Basically what I want to do looks like this: (DO_STUFF is the stored proc)
SELECT A.ID, A.NAME, A.AMOUNT,
DO_STUFF(A.AMOUNT)
FROM SOMETABLE A
Any help on how I can accomplish this or if it...
Hi, I am relatively new to XSLT and have kind of taught myself the basics. What I am trying to do is declare a fo:table object inside a template. However when I do this I get an error. This is case not only with fo:table but with any "fo" tag inside the template. I am wondering what I need...
Hi, I have a situation where I need to insert into 2 tables that are related through ID and V3DETAILKEY.
The tables are:
V3DETAILSERVICE (ID VARCHAR(9), V3DETAILKEY VARCHAR(20), SERVICE NUMBER(7,4))
V3DETAILSALARY (ID VARCHAR(9), V3DETAILKEY VARCHAR(20), SALARY NUMBER(9,2))
So, the ID is...
Hello, I have a situation where I need to insert into 2 tables that are related through ID and V3DETAILKEY.
The tables are:
V3DETAILSERVICE (ID VARCHAR(9), V3DETAILKEY VARCHAR(20), SERVICE NUMBER(7,4))
V3DETAILSALARY (ID VARCHAR(9), V3DETAILKEY VARCHAR(20), SALARY NUMBER(9,2))
So, the ID is...
Hello,
My java application writes text to a file. I would like to change the font of certain strings but I am not sure how this is done. Any ideas?
Thanks.
Hi,
I am trying to read a jpeg file and output it into a spreadsheet file as the first line in the spreadsheet. Any suggestions on how to read an image and then print it into a file?
Thanks,
Terry
Hi there,
I built an application with JBuilder. I would like to create a shortcut on the desktop to run the application but I don't think there is a JAR file. So I guess my question is, how can I create a JAR file for my application?
Thanks,
Terry
Hi,
I have recently changed computers and have run into a problem.
I copied my work from my old machine onto the local network then I copied from the network to my new machine. My java application that I have created runs fine on my old computer but not on the new one. It does not...
Hi,
I have a java application that I run once a day, and it usually takes about 30 minutes to complete. Now I have noticed in the task manager that only about 2% of the CPU is being used as the application is running. I have tried giving the javaw process in the task manager a high priority...
Hi everyone,
I am relatively new to JBuilder. I am trying to create a shortcut to run my application. I can run the application fine by going to run->run program, in the JBuilder menu, but I am have some difficulties trying to create a shortcut to it.
This is the message delivered within...
Hi, my program is closing if the user presses "yes" or "no" when asked if they want to quit after pressing the "x" on the top right corner of the program. I am wondering how I can keep the program running if they press "no". Thanks.
Here is the code:
public void closeProgram()
{
int...
Hi, I have used a mySQL database in the past and used the LIMIT function to limit my query results. eg. LIMIT 10 at the end of the query would restrict the results to the first 10 records. I am wondering if there is a similar function in oracle? Thanks.
I am wondering if there is an oracle equivalent to the mysql LIMIT function.
This is what I am trying to achieve:
SELECT *
FROM data
WHERE disabled_date > last_day_empl_paid_date
ORDER BY sequence_num DESC
Limit 1
Hi, I am trying to write a query to select some records from our database where the disabled date is greater than the date last paid by employer. In the database there are multiple similar records but the sequence number might be different, ie The sequence number might be 1, 2, 3, 4, etc. I...
I would like to know how i can manipulate the now() command to make it actually mean yesterday.
basically I need now() - 1day
Is there some way I can achieve this? perhaps now() is not the proper function to use, any help is much appreciated.
Hi, ok I have a bit of a problem. What I need to do is select info from table A only if that info is not in table B. Here is what I have:
SELECT DISTINCT A.TitleType
FROM organizationlots A, TitleCategory B
WHERE A.TitleType<>B.TitleType
This code selects all from Table A regardless of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.