1,488 Topics
 | |
| | 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() { …  |
| | 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 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 …  |
| | [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 … |
| | [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, … |
| | |
| | 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?? |
| | 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 … |
| | 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 … |
| | As a FOSS (Free, Open Source Software) advocate, I find myself in a state of shock over what I've observed over the past ten or so years in this realm. If I asked you to name the most successful open source companies (Companies that derive the majority of their income … |
| | 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.. |
| | 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 |
| | 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 … |
| | 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 |
The End.