1,488 Topics
 | |
| | 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 … |
| | I have a question involving interaction with oracle. I have a program that submits data to a SSRS report which is pulling data from an oracle database. Basically what I need to do is have a string of text passed in and return all records where a job id field …  |
| | 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 … |
| | Hi guys, I would like to know is it possible to connect and create databases locally on my Mac or even windows? using Oracle SQL Developer. I have installed Oracle SQL Server with XAMMP but this doesn't seem the correct way. Hope someone could help.  |
| | How can I learn oracle easily? what are the softwares required for testing & running oracle code |
| | I am using GUI in netbeans to create a combo box. I want to import all data of a column from database dynamically not manually to a combo box.  |
| | Please help. I try to run a simple Oracle query using the Xmlelement on Toad and SQLPlus and obtain an Access Violation error in Toad, while SQLPlus runs for a while before returning an End-of-file Communication File chanel error indicating its disconnecting. Is there setup required to use this function? … |
| | hi what is the query to fetch duplicate records in oracle table.  |
| | I am calling a Stored Proc in Oracle using Hibernate. Procedure: create or replace procedure GetStocks(email in VARCHAR2) is BEGIN execute immediate 'SELECT * FROM stock WHERE email=email'; END; Java Code Query query = session.createSQLQuery("CALL GetStocks(:email)").addEntity(Stock.class).setParameter("email", "abc@xyz.com"); System.out.println("QUERY:"+query.toString()); System.out.println("QUERY SIZE:"+query.list().size()); List result = query.list(); for(int i=0; i<result.size(); i++){ Stock st …  |
| | i wantto know how to delete,update,insert a specific row using oracle10g as database in visual studio with asp.net, using gridview checkbox and sqldatasource. |
| | Hello everyone, I want to create a project in oracke. So can anyone help me how to configure PHP and ORACLE after installation of XAMPP ??? |
| | HI Friends, SQL> edit; SP2-0110: Cannot create save file "afiedt.buf" how to fix this problem. |
| | Hi..i m creating a project in turbo c++ with os windows 7 and i want to implement it dynamically.so how connectivity of oracle is possible with c++?(turbo c++ or dev c++)  |
| | hello everyone.. I am trying to connect a simple application to Oracle XE database. But when I run this program , the else part of program is running. Can Anyone tell whether I hav ewritten the code correct or not. import java.sql.*; public class jbc { public static void main(String … |
The End.