[oracle] Forum Topics

HELLO, in my database, i have the following table: video_hire([U]vide_hire_id,[/U], hire_date, video_code, Cust_membship_no, returning_date, hire_cost) video_code is (fk) ref: to VIDEO_LIST, cust_membship_no is(fk) ref: Customers IM TRYING TO code a PROCEDURE or FUNCTION TO to calculate the ammount of hire from one customer, and print the total, as well the …

Hi to all I have inserted .bmp files to Oracle DB with Delphi7. There is "save to file" option in Toad when on double click blob field. Now I want to save blob data to disk on Delphi7. How do we do it? Thanks in advance.

i installed Oracle 9i.when i go Start->Program->Oracle-oraHome90- i did not get Isql * plus.Kindly let me know the idea.Any help would be highly appreciated.Kindly find the attachment also.

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. …

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 …

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 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

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 …

I'm having a really hard time trying to figure out how to make the following search: "Find the sellers specialized in selling cars of the year (They can only sell cars produced during a specific year, example 2010). The tables I have are: Seller: {[U]Seller_Id[/U], Name, City_Residence} Business: {[U]Car_Id,Seller_Id[/U],Year_car_Produced, Business_Date, …

Hi, I have a table in Oracle. Here is the table. [CODE] SQL> select * from test; SDI NAME ---------- --------------- 123 Tapas 345 PradEEp 567 Jagadish 789 Giri [/CODE] I want write this data into a CSV file. I tried this but i am not able to redirect or …

Hi, I m very mew to the oracle. I want to teach transaction and locks to the diploma student. I searched so many examples of these topics from the Google Search engine, but fail to search simple and short example. I understood the topics, but can't find simple example. Will …

there is a procedure which have 6 input parameters, 1 for each. All input parameters are of type char. i need to convert those into respective datatypes and insert the data in table. how to convert char to date and int datatypes?