1,488 Topics
 | |
| | Hi all, I am new to database and i want the links for Oracle 10g or 11g for Windows 7 64 bit and I want the link for installation steps also. please provide me the link to download the Oracle software and installation steps. I just got a job as …  |
| | Hi, I have an problem with connecting Oracle 10g express edition with java. I am accessing my Oracle 10g with the following URL: localhost:8080/apex I am using the following code: [CODE]try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:xe","hr","hr"); System.out.println("Connected Successfully To Oracle"); con.close(); } catch(Exception ex) { ex.printStackTrace(); }[/CODE] Is the … |
| | Hi all, I am new to Oracle TOAD. I just got a job as a database developer in which it deals with TOAD and Oracle. I want a small help in finding a nice tutorial for beginners. I have a little bit knowledge in backend like Oracle only school knowledge. … |
| | I have a vb 6.0 project which uses access as a database. but i need only oracle as database. Will anybody pls tell me how to change it to oracle database. Does it requires the Complete change in the code of the project or only a little changes. i am …  |
| | Hello, I am fairly new to SQL and PLSQL and am having a problem debugging some code for triggers, the compiler keeps saying that the trigger is not initialized properly. Here is a posting of the code. This is for a homework assignment, but I am lost so I would … |
| | Hi, I have 2 differnt views v1 in one schema and v2 in another schema. I want to combine/join these 2 views. View v1 is in student schema. View v2 is in information schema. This is one schema: student describe v1; name varchar(300); age number pno number This is another … |
| | Hello, How to run command SQLLoader Oracle in c#. I try my sourcode for run this SQLLoader, but nothing happen and error "No process is associated with this object.". Please tell me how i fix it. Thanks. This is my code: [CODE] System.Diagnostics.Process process1; process1 = new System.Diagnostics.Process(); process1.EnableRaisingEvents = …  |
 | is it necessary to install any other s/w like apache etc if i have WAMP or XAMP on my machine to connect php with oracle?  |
| | Hello, How to import csv data into Oracle using c #. Where data to be imported 3GB in size and number of rows 7512263. I've managed to import csv data into Oracle, but the time it takes about 1 hour. How to speed up the time it takes to import … |
| | Hi, I want to download Toad for Oracle database i.e (SQL querying, access, modification and editing) but the oracle server is in Solaris. I have windows XP OS. How to install toad in windows and connect to Solaris for the DB? Where can i download toad and work with Oracle? … |
| | Hi there, thanks for all the help you're providing overhere to everybody. I would like to know if It is possible to have an auto increment column that is somehow attached to the value of another column. so it keeps increasing as long as that value of the other column … |
| | Hi, I was told to build a application that will encrypt data and migrate data from one database platform to another platform. Please i do not hae a clue where to start from as i am a newbie to database. Any info will be well appreciated |
| | Hi Guys, I am trying to make a simple connection from my desktop(local computer) with Oracle 11g which is installed on windows server 2008 R2.Now I have problems with the ConnectionString. could you please let me know how I set a correct connection String while I have parameters like these: … |
| | Hi Guys, I need some help. I don't understand how to do an alter table statement. I had a lab last week that used it and I couldn't get mine to work. [CODE]DROP TABLE ENROLLMENT CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE_SECTION CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE CASCADE CONSTRAINTS PURGE; … |
| | Hi all, Firstly- I've written a PL/SQl procedure to what I'm asking about in this posting. However, I'd like to do it with a single(or nested) SQL selection statement (I don't think its possible, but I'm no expert and was interested to hear if anyone has a solution- or just … |
| | Please send me the working link of 'free downloading oracle9i' and steps for downloading it. Thank you! |
| | Hi to all, table name: mail email name [email]abc@gmail.com[/email] abc [email]def@rediff.com[/email] def [email]pqr@yahoo.com[/email] PQR [email]xyz@daniweb.com[/email] XYZ ======================================= QUERY: List all email and names in lower letters without any blanks. ======================================== I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data. Will you please help … |
| | I was trying to solve this query: [B]Find all the students who have taken the course taken by a instructor named 'XXX'.[/B] Well the division operator of relational algebra can do it easily. I want to know how to use the division operator in sql(if there is any) or any … |
| | [code]{ sqlplus -S ${DB_LOGIN} << eosql set echo off; set feedback off; set heading off; WHENEVER SQLERROR EXIT FAILURE; ${1} }[/code] can i pass the qurey as a prameter to this function? will that query get executed if the query is echoed as ${1}? |
| | //Hi, //i create following table Table name : person ID AGE FNAME LNAME 1 10 Geek Greek 2 20 Seek Bells 3 30 Creek Dells 4 40 Sreek Sells[/B] // I wrote following procedure which is run successfully. Create or replace procedure proc1 as cursor person_cursor (pAge number) is select … |
| | Hello Friends, I am new to .NET and to this forum too. I need to move approx 2K rows from an oracle to SQL server table every week. I am planning to develop a C# console application to achieve this. Any ideas how to start and what is the best …  |
| | hi. In the later versions of mysql5.1 we can create an event which can be scheduled accordingly. What is the siimilar way to create in oracle which can be scheduled. Thanks in advance |
| | please help me to solve this problem,i want to insert data by checking the multiple entries in my form and retrieve the same data, the check box must checked the corresponding field retrieved. |
| | Hi friends... My system is MS WINDOWS XP, Professional Version 2002 Service pack 2... I Want to Connect PHP with oracle... I searched in GOOGLE... Source: [url]http://me2learn.wordpress.com/2008/10/18…[/url] I Followed the steps given by them... but still i'm not able to connect... I installed PHP and APACHE... PHP version: php-5.3.4-nts-Win32-VC9-x86 Apache … |
| | Hello, I am trying to write an sql query in oracle that solves this question: [B]List top three customers from each state that has the most number of orders (4 points).[/B] Here is my query now that is just ranking every customer based on the # of orders they have … |
| | Hello, Question: List the top 25% of employees in terms of sales. Your list should include employee number, last name, first name, total number of orders, total sales. Here is what I have so far (not sure if my inner joins or even the query is totally correct): select e.employee_no, … |
| | Please let me know how to drop constraints within a table having no names. :-/ |
| | does anyone of you knows a article about ORACLE REPORTS? thanks :) ps: please post the site  |
| | [ICODE]select eid from(select count(*) cnt,eid from certified group by eid)as foo where cnt=(select max(cnt) from (select count(*) cnt,eid from certified group by eid)as goo);[/ICODE] This query displays the eid with maximum no of entries in the table certified. Which in this case is no. of aircraft licensed to an eid. … |
 | Hi I am working on a procedure to log the users and times of our reports. Our reports are all executed from stored procedures. The generic logging proc which will be placed in the 30+ report procedures. I'm having a problem with getting the start and end times for the … |
The End.