[oracle] Forum Topics

How to connect c++ and oracle ? i am working on a project Multiplex management system using c++.... but it really tedious task to store and handle all data in file... please help me with the procedure...!!

Hi team, 1)There are 2 independent AIX platform available with 10g database running on it Mainly-Production and the other test machine 2)There is 2 tables which needs to be brought down from production to test machine I know expdp/impdp plays the key<commands as below-correct me if the below command needs …

Hey all ! I want to create a new data-type called 'Phone' so that I can use it when create a new Attribute, with its form is : xxx-xxx-xxxx For example : 123-543-8978 And when users want to UPDATE my table, they must enter a string with the same form …

how can we draw the E-R diagram for a particular table

I have a problem with Oracle as well.. After i installed Oracle express.. I tried it for the first time and it worked. The next day, i tried to bring it up on my computer and i kept getting message that it couldn't connect to the server even though my …

Hi, I have this source code and it is copiled without problems. But when I debug this program than it write error 24960. This is my program: [CODE] #include <iostream> #include <occi.h> using namespace std; using namespace oracle::occi; #define USER "SYS" #define PASS "****" #define DB "XE" int main() { …

Here is my code for a JDBC program to do account transfer. I am having trouble with my transfer code. Can anyone help. This is urgent. [CODE]import java.sql.*; /***************************************************** class BankAccountTransfer { /** Make a transfer from two accounts owned by same customer. * @param custNum the 6-digit customer number …

Hi, I am trying to run some simple updates using java in Oracle(10g). I have a simple java program to do it. Running the code using Eclipse IDE. The strange thing about it is that the connection is fine. If I run a [B]select[/B] query, it works fine. However if …

hi all I'm trying to write a procedure/function in pl sql that get the user's password, encrypting it with md5 algorithm and inserting it into the USERS table. any 1 knows how to do so? i know that md5 is not a good algorithm but i dont care cuz its …

Hi all ! I 'm a newbie in SQL and has just install the Oracle 10g Express Edition. When using its SQL Command in the Web-interface, I took an error with the GROUP BY, as follow : First, I create a table DEPARTMENT, here 's the code : [CODE] CREATE …

Hello. Im wondering if anybody can help me out on a problem I am having for my SQL class. I have been going round in circles for the last three hours and am about ready to give up. The brief asks that I design a query that performs a division …

hello experts... i have a table employee and in it are attributes like name gender,birthdate...etc.. apart from this i want to automatically generate d employees age from d current date....how can it be done?? thankyou...

Hi thabotharshan here from SriLanka (one of very dangerous country in the world and also one of the beautiful country in the world). i think some of you heard about the srilankan confilct.My Nationality iS Srilankan Tamil. Ok I am a MIS student . Language: small knowladge about C,C++,J2SE,J2EE javascript,html,css …

Hi all. Does anybody knows how work with oracle DB in Visual Studio 2010 i was able to connect to the DB(meaning i can see the tables in the Server Explorer), but i cannot add the reference to the System.Data.OracleClient like it is able in VS 2008. Thanks!

Hello, I've been trying to find a way, using Oracle Express, to return more than one column but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID column to be distinct. Can this be done in Oracle? [code=sql]SELECT DISTINCT Job_ID, …

Question: Write commands to declare character variables named faculty_last_name, faculty_first_name, and faculty_phone. Assign the value ‘COX’ to faculty_last_name, ‘KIM’ to faculty_first_name, and 7155551234 to faculty_phone. Write program commands so that the program displays the output exactly as follows: Kim Cox’s phone number is (715) 555-1234. everyone can teach me???

What the hell is up with [URL="http://www.oracle.com"]Oracle[/URL] lately? First, they stopped giving away the Solaris operating system and now they have some big announcement planned for next week at the [URL="http://en.oreilly.com/mysql2010"]MySQL Conference[/URL]. Should we hide our wallets before we listen? To me, Oracle has morphed into [URL="http://www.microsoft.com"]Microsoft[/URL] II with all …

Hi it's probably a very basic question but I just wonder if it is ok to restrain foreign key to more than one column, e.g. there is a hypothetical situation where a company collects fruits, let say apples , from farmers. So, a database builts up, and there is a …

Hi people, Im trying to handle an exception in my servlet by res.sendRedirect to another page..but it is not redirecting to the page i want, instead its going to a HTTP Staus 500 error page detailing the full stack trace..can someone tell me what might be wrong here, ive attached …

hi All, please i need someone to help out with a template or sample communication /implementation diagram for the follwoing spec: 3 servers on RAID 1, DELL PE R300, with RAM 8G and hard disk 1TG each 1. VMare ESXi a. HR/ Finance application running on Windows Server 2008, 2GB …

[URL="http://www.mysql.com"]MySQL[/URL] users listened intently Tuesday, April 13 at O'Reilly's MySQL [URL="http://en.oreilly.com/mysql2010"]Conference[/URL] to Edward Screven, [URL="http://www.oracle.com"]Oracle[/URL]'s chief corporate architect, while he announced Oracle's grand plan for MySQL. What they heard was that Oracle is interested in MySQL, will invest in it and nothing should change for the community version of MySQL. …

Im running windows XP Professional I have all of the latest updates on my laptop and I just downloaded the latest version of SQL Developer but when I try to open the program I receive this error “Unable to create an instance of the java virtual machine.” Ive been looking …

I have an app where I keep getting this error. This is a c# .net 3.5 app running on a windows 2003 server with IIS 6.0 connecting to an Oracle 10g db. This app had no problems during testing where it was connecting to an Oracle 9i DB but once …

I posted this on Oracle Forums to the sound of crickets chirping. This question entails more Oracle specific tasks then java but since my code is in java, here goes" Hello, I have a java package where I am attempting to implement a database Change notification registration and listener. I …

mytable1 contains the customers information (phone, address, first name, customer code, last name...) mytable2 contain the flights (charter, date, destination,customer code...) They are joined by the customer code. My goal is to print names of customers that have more than the average number of charters [CODE]SELECT cu.cus_fname, cu.cus_lname, COUNT(ch.char_trip) ch …

[CODE]<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Samples.Controllers" schema="I_USER" assembly="Samples" > <sql-query name="PROCEDURE1" callable="true"> <!--<return class="empdetails.cs" />--> <return-scalar column="iusrfname" type="String" /> <return-scalar column="iusrlname" type="String" /> <return-scalar column="iusrlinname" type="String" /> <return-scalar column="iusremailid" type="String" /> <return-scalar column="iusrmobileno" type="String" /> <return-scalar column="iusrrmrks" type="String" /> <!--<return-scalar column="iusrcreated" type="DateTime" />--> call PROCEDURE1(:pr_userid,:iusrfname,:iusrlname,:iusrlinname,:iusremailid,:iusrmobileno,:iusrrmrks)<!--,:iusrcreated)--> </sql-query> </hibernate-mapping>[/CODE]

i want to connect an vb6 form with oracle9i so that i can insert update n delete ,what are all the ways i can connect to db , anyone help me with code , form one has four fields student name , id dept, year n college, if i click …

When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus.

Oracle 10g I have been trying to import an excel .xls spreadsheet into oracle. I can import everything fine but whenever I need to import a sheet that includes dates it does not work. Is there a special formatting I need to do with excel(THE DATE COLUMN??)(I have tried just …

This has taken many hours of mine. I have to get this .Net app to run on an XP system. Someone seems to have messed up some files so conn.Open() in the C# is causing this error: [CODE]Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, …

Hi, can you help me? I want to load txt file to database (Oracle). But I like to use PL/SQL. Do you have any idea, how I can do it? Thanks

It's true. [URL="http://www.oracle.com"]Oracle[/URL] is now, with its acquisition of Sun Microsystems, the world's largest purveyor of open source software. Does that surprise you? It did me too, until I started digging and realized that Oracle has a history of supporting free and open source software. Their support didn't start with …

Hi I have to work with oracle application express 3.2 I have some doubt on installation: 1.whether i need to load oracle 9i release 1 or release 2 2.whether it is possible to work with windows vista/xp? 3. what are the requirements to install apex 3.2?? i am new to …

I have been trying to inset an excel spreadsheet into oracle. I can import everything fine but whenever I need to import dates it does not work. is there a special formatting I need to do with excel? I have tried every step that I can possibly think of. whenever …

hi there....... i m doing a project on matlab.......i wanna know how to connect oracle 8i or oracle 10g with matlab..... or whats d connectivity??

i have created some tables in XML which perform all DML operations perfectly. now my question is how can i give security to these tables as we get in databases(sqlserver,oracle).. Please help me out in this..and try to give anwser in simple way

[code] Private Sub PopulateProductList() Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Dim strSQL As String Dim objListItem As ListItem Try strSQL = "SELECT [Sr No], [First Name] FROM [Lani]" con = New OleDbConnection(connectionString) con.Open() cmd = New OleDbCommand(strSQL, con) dr = cmd.ExecuteReader() lblani.Items.Clear() Do While …

Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do …

I need to buy some books on database systems. A complete course from start to end. Well the books should have some theoretical explanation but should focus more on practical ideas and solutions. I need to learn sql, xml, xhtml, rdbms, oodbms and whatever other scripting languages there are. I …

Hi I am getting weird error with oracle connectivity. Immediately after the open() call, the connection shows as closed. I am not able to figure out whats going wrong. The same code works if executed differently. Line: This piece of code throws error [CODE=syntax] bool objState = false; if (Program.orConn …

Am using wordpress for web hosting. Stil now am using mysql database. But now i want use oracle is it possible or not please reply me any one... Thank you..

Hello, Im working on some homework for school a data base class... Ive done all the queries except the last, [URL="http://www.funkohland.com/Other/Temp/IMG_0198.JPG"]Tables[/URL] Specify the following queries using relational algebra and show the result of each query. Find the names and addresses of all employees who work on at least one project …

i am using oracle 8i.i want write a query to display who is the person & his tuple remitted or maximum amount used.how can i display it

hi i m working on Student Database Management system, I have used button s for insertion, deletion, and update. Insert and delete button is working but update's click gives syntax error: Pls help as soon as possible: [code] Try Dim com As New OleDbCommand com.Connection = con com.CommandText = "update …

Hi All, I want escalations mails to be sent to higher authorities after the specified duration has been exceeded. Eg: If a client has a task to be performed in 2 hours and if it is with him for more than that then a escalation mail should be sent to …

hi, any one plz tell me how to connect oracle database with the help of struts . i am begginner in struts. thank u

Hiya, Discoverer admin/desktop. There is this issue we do have in my place of work. We use a the tool called discover admin /desktop. The discoverer desktop is only accessible till 4:59pm exactly when it is 5:00pm it doesn't work and immediately it is 6:00pm it start working again. I …

hi guys, is this possible [CODE]Private Sub Command1_Click() Adodc1.Refresh Adodc1.Recordset.Update Adodc1.Recordset.Fields("Balance") = Val(Text1.Text) - Val(Text2.Text) Adodc1.Recordset.Fields("Amount_Paid") = Val(Text2.Text) + Val(Text3.Text) Adodc1.Recordset.Update Adodc1.RecordSource = "SELECT * FROM Tuition_Fee WHERE Tuition_Fee_ID_PK = " & Form2.Label16.Caption Adodc1.Refresh Text4.Text = Adodc1.Recordset.Fields("Total_Tuition") Text3.Text = Adodc1.Recordset.Fields("Amount_Paid") Text1.Text = Adodc1.Recordset.Fields("Balance") MsgBox "Tuition Updated" Printer.Print " Official Reciept" …

Hiya, My company is about to up upgrade from Oracle Application R11.10.5.2 to R12. we a document to convince the management about the upgrade. We need to produce a document on why and how we can effectively migrate to Oracle Release 12, which include references to those who has concluded …

hi can u tell me how to connect to oracle from jsp please.i