[oracle] Forum Topics

Hi, I am currently working on joining 2 tables, however those tables have different number of columns thats why I have difficulty on joining them. I tried to use FULL OUTER JOIN, close result but still not my expected output. You can kindly see my attachment to see the scenario. …

How to convert oracle forms to php, is there an easier way to do that.

Hello, I want to create tables in database (using SQL) and add foreign keys to each table refering to the other one. For example: CREATE TABLE ONE( ID INT NOT NULL, NAME VARCHAR(20) NOT NULL, TWOID INT NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (TWOID) REFERENCES TWO (ID) ON DELETE …

can someone help me how to connect thm both?

hi, I have installed oracle 11g in windows 7 32 bit, Oracle actomatically starts when windows starts, I want to start oracle manually, how to stop oracle. kindly give tips, thanks in advance.

Hello everyone, I am having a hard time finding the information I need and am hoping you all can help. I am using sql developer and I have a database named us that holds 5 tables and a database named uk that holds the same 5 tables. It is a …

Hey everyone, I have a query that is to return a set of rows depending on its WIPDataValue. Say for example, I have added new WIPDataValue which is 1-9. So obviously the resulting set should have 9 rows and on those 9 rows, the value of each is 1-9. This …

I made c# asp.net web applciation with oracle 10g database using visual studio 2008. It works fine with local environment. After I published on my web server and received the following error: *Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot …

my report builder is having problems calling a form. i need the procedure. am using dev suite 2

Below is the sample code working fine in 10g and not working now in 11g. CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS import java.sql.SQLData; import java.sql.SQLException; import java.sql.SQLInput; import java.sql.SQLOutput; import java.util.List; public class PSTest implements SQLData{ public String sql_type = "PS_TEST_TYPE"; private String id; public String …

Hi, Can we get a SQL query, to display all the dates between two given dates eg. if date1=21-mar-2007 and date2=25-mar-2007 then the query should display all the dates between those two given dates i.e 22-mar-2007, 22-mar-2007, 23-mar-2007and 24-mar-2007. Query should not contain any plsql coding. Regards.

Hi Guys, I am working with oracle Forms 11g and i want to navigate from one block to another, i used to use GO_BLOCK('BLOCK_NAME') before(10g, 6i), but now its not working in 11g i did a small resarch on the internet and its saying that GO_BLOCK must Work!! Any Ideas??

I used following code to connect oracle database from C#. But i get this error "**invalid login credentials**" using (Oracle.DataAccess.Client.OracleConnection cn = new Oracle.DataAccess.Client.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;") { cn.Open(); } While if i try following code to connect database from C# I succeed. using (System.Data.OracleClient.OracleConnection cn = new System.Data.OracleClient.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;")); …

hi, i have 2 tables: CUST and ORDERS CUST contains cust_num, cust_name, cust_phone ORDERS contains cust_num, order_date, order_amt i want to list all the cust_names and their last order date and amount how would i code this? thanks.

I am developing a web application for which I need to access a remote oracle database. I am using eclipse EE IDE and apache tomcat server. I have added all the dependencies like ojdbc to the project as well as to the deployment descriptor. But when I try to run …

Hi all , Here comes the same general question. I want to store the text ( you can call 'paragraphs' ) . What is the best way to do that? Files? OR database is OK? Thanks in advance :)

Last week saw the discovery of YAJE: Yet Another Java Exploit. Sadly, Java vulnerabilities are neither new nor uncommon and the bad guys are quick to exploit them in the wild. Some claim that Oracle is in too much of a rush to extricate itself from this unholy mess and …

I am making a desktop application using vb.net and oracle and crystal repot. How can I upload the application on the web? For creating web page: upload css and HTML files to the web server using FTP(if the contents are incompleted, but still can see on the web) For the …

Some one help me with the download link for oracle 10g ee for w8

Using SQL I have to SUM the total of each game but I can only select the games that have more than 10 scores in total . So `select GameNo,sum(goals) from tblGame, tblAthlete.` But I'm stuck on the 'where' bit.....`select GameNO where (sum(goals)>=10);` So not only do I have to …

I have an issue and I would like to know how I should go about this. I have two tables. Athlete and EachAth_Games create table Athlete ( AthleteID INTEGER NOT NULL, Firstname varchar(10) NOT NULL, Surname varchar(10), Position varchar(1), TeamID INTEGER NOT NULL, CONSTRAINT pk_Athlete primary key(AthleteID, Firstname), CONSTRAINT Player_FOREIGN_KEY …

hi recently i have installed oracle 11g and i try to work through oracle enterprise manager browser to start up the local host there i found "Host Credentials" i have not set any user name and password for my os while installing i am using windows 7 what will be …

Hi . I installed oracle 10g in D Drive(Because C drive is full). But when i try to uninstall , i cant see that in "add or remove programs". How to uninstall it?.. Any solutions..

Hi How can Iremove all object that Im created in oracle database. I have 8 tables and I would like to remove all which commans should I use?

Hello all, I'm performing the oracle bulk copy upload operation. There are 10 columns data which needs to be uploaded in oracle database table. The data is getting uploaded in the table for these 10 columns using a datatable. A datatable is being populated from the list. However, there are …

How can I insert two row to supplier table? CREATE TABLE supplier ( supplier_nr NUMBER(10), supplier_id VARCHAR2(20) NOT NULL, price NUMBER(10) NOT NULL, CONSTRAINT supplier_supplier_nr_pk PRIMARY KEY(supplier_nr), CONSTRAINT supplier_supplier_id_fk FOREIGEN KEY(supplier_id) REFERENCES varugrupp(supplier_id) );

what is the driver and url for oracle 11g and kindly suggest me suitable jdbc jar file for oracle 11g

I'm trying to create a table writing in SQL and I need to validate the 'Date of Birth' field 'Players must be over 16 years of age' So how should I validate this. my table name is : Players field name is DOB and the datatype is 'DATE' I tried …

Hi I try to insall Oracle SQL Developer 3.2.2 on windows 7 64 bit ,but I dont know why I cannot connect to server I got this error? http://ubuntuone.com/68jUmnjxm1458xARIaDNcL by the way any one know who ca I unstall Oracle SQL Developer 3.2.2 from Win7 64bit?

Hey Everyone, I have table called vdet_sa_archive and in that table there are so many fields and i want to access the data on datetime range. sample data in table starttime endtime 1 14-02-13 01:30:15.000000000 AM 14-02-13 02:01:57.000000000 AM 2 14-02-13 4:30:01.000000000 AM 14-02-13 5:30:01.000000000 AM 3 14-02-13 01:30:01.000000000 PM …