1,488 Topics
 | |
| | what is the SQL command (Query) to create category and subcategory in oracle thanks for your time.  |
| | Hey everyone I need some urgent help please. I don't know how but I need make a Time Dimension of an Oracle Table using c#. What needs to happen is: -I want to use Order_Table's Date Column to Create a new table Time_Dim with columns OrderID, Year, Month, Week, Day. …  |
| | Hi everyone I need help please. I need to create a Time Dimension of an Oracle Table using C#. I have no idea how to do it. Any Suggestions? Thanks in Advance |
| | Hi All, I have two machines, one Solaris and another Linux. On my Linux machine , i have Oracle10g installed and have one instance(say firstInst). I have Oracle 10g installed on Solaris also. When i try to connect to this firstInst, from Solaris , i get error like *sqlplus sys/sys … |
| | 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 …  |
 | Does anyone know how to connect an oracle object oriented database to c#? Using ADO.NET Entity Data Model, i see just relational tables, and i need to work with object tables. Thank you verry much! |
| | |
| | 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 … |
| | I am tring to recreate my oracle database -> sql server 2008. I never used sql server before, so I am using sql server management studio. I could create tables and views. The views I created using sql server management studio GUI has data in it. Now, I tried to … |
| | 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 … |
| | I made c# asp.net web form application with visual studio 2008 with oracle 10g database using Oracle.DataAccess. When I start debugging or start withoutdebuggin from visual studio, it workd fine. (visual studio and oracle 10g server and client are installed in my pc). I publish the application and use ftp … |
| | 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 have migrated my Oracle Developer 6i Forms and Reports to Oracle Developer 11g. Everything works fine except three of my batch report applications. They generate 300 to 400 reports each, which in 6i were stored (in pdf format) in a Windows network folder. From the folder they were emailed … |
| | 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.