2,627 Topics

Member Avatar for
Member Avatar for thabotharshan

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 …

Member Avatar for maceman
0
36
Member Avatar for severman

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!

Member Avatar for kvprajapati
0
451
Member Avatar for Billingsley

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

Member Avatar for Quacau corp
0
23K
Member Avatar for avatarkk

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

Member Avatar for anatolse
0
203
Member Avatar for khess

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 …

Member Avatar for jwenting
-1
433
Member Avatar for nkswapnil

[COLOR="Red"]Hi Friends, Need your Help !!!!!!!!!!!!!!!!!!! Last month, i took assembled pc .....which contain processor "pentium D", 2.8 GHZ processor speed, 1 gb ram, 160 GB SATA HDD... First of all, i want to clear, in my pc there is no heavy application like visual studio ,oracle kind of software …

Member Avatar for nkswapnil
0
279
Member Avatar for oggiemc

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 …

0
53
Member Avatar for fkcares

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 …

0
73
Member Avatar for QueenKirsty

I have been asked to make a proposal for a new IT testing & development environment at work but I have no idea where to start. We are a small team of 3-4 developers and will be developing in a variety of languages for a variety of applications, inculding: - …

Member Avatar for Nick Evan
0
127
Member Avatar for khess

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

0
550
Member Avatar for moone009

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 …

Member Avatar for debasisdas
0
79
Member Avatar for cgyrob

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 …

Member Avatar for cgyrob
0
202
Member Avatar for eggmatters

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 …

0
156
Member Avatar for asian_al

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 …

Member Avatar for MeSampath
0
99
Member Avatar for bonyshine

hello every one ! im computer science student , i have 9 months for delivering my graduation project . i dont have idea of what about it going to be ? but im searching about a nice ,creative idea . i have knowledge about c++, c#.net , java , oracle …

Member Avatar for highschool
0
501
Member Avatar for sandeep210

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

0
114
Member Avatar for Prakash_8111

Hi All, I am developing a mysql monitering tool , So I don't want to give password inside the script, the script should able to access the database from OS user authnetication. Can you please help me here , how to access mysql database without prompting / or giving password …

0
61
Member Avatar for prabooh

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 …

Member Avatar for jhai_salvador
0
86
Member Avatar for lakshma.sugunan

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.

Member Avatar for emsm
0
278
Member Avatar for moone009

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 …

Member Avatar for debasisdas
0
166
Member Avatar for psyb0rg

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

Member Avatar for debasisdas
0
2K
Member Avatar for 1manik

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

Member Avatar for debasisdas
0
51
Member Avatar for khess

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 …

Member Avatar for songjie
1
3K
Member Avatar for ausmaya

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 …

Member Avatar for ausmaya
0
87
Member Avatar for moone009

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 …

Member Avatar for debasisdas
0
52
Member Avatar for jamesparkhyde

Hi, forum members, I'm Jim Hyde. I live on an island in Puget Sound just north of Seattle Washington. It is very beautiful here. My wife and I moved here about 6 years ago. Before that I was a contractor in Silicon Valley, building business systems using Oracle. I came …

Member Avatar for jephthah
0
83
Member Avatar for gabrielhuebsch

I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than …

0
110
Member Avatar for dewyShaikh

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

Member Avatar for debasisdas
0
49
Member Avatar for amitshrivas

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

0
56
Member Avatar for achiman

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 …

Member Avatar for debasisdas
0
97
Member Avatar for athar89

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 …

Member Avatar for taneval23
0
90
Member Avatar for nirvana74v

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 …

Member Avatar for nirvana74v
0
428
Member Avatar for khess

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 …

Member Avatar for kimgr
-1
804
Member Avatar for claireweb852

I have to start by thanking the membership for all the info I have gleaned from this site even before joining. :) I spent 30 years in IT - analyst, developer, team leader - half on big IBM mainframes (MVS, Cobol, IDMS), later on client-server platform (Unix, Oracle, Sybase, ASP). …

Member Avatar for BestJewSinceJC
0
57
Member Avatar for selvasoft

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

0
44
Member Avatar for freddyvf

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

Member Avatar for manish.nankar
0
69
Member Avatar for devs.dr

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 …

Member Avatar for devs.dr
0
111
Member Avatar for agarwalsrushti

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 …

0
40
Member Avatar for kishore.nath07

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

0
58
Member Avatar for holard

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 …

Member Avatar for jwenting
0
83
Member Avatar for lee.j.baxter

Hi, I've worked with the Speech API in the past (VB6), and I'm now looking to use it in my project. For those who haven't read previous posts of mine, I'm developing an AI system in C#/.NET which learns from the internet. Well, I'm going to say I told a …

Member Avatar for kvprajapati
0
207
Member Avatar for holard

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 …

0
57
Member Avatar for anfeerpt
Member Avatar for Blaine Tuisee

I am writting a query in SQL Developer. I have a field in the table that holds a timezone. I need to set the query to use that timezone. Any ideas? Here's the query I have so far: [CODE]select to_char(dateoftransport, 'MM-DD-YYYY') as "Date", dispatch_id as "Dispatch, vehicletype as "Dispatch Type" …

0
75
Member Avatar for awo

Is it possible to create a trigger on a synonym on a database Links

0
54
Member Avatar for awo

i am trying to simulate an alert for transaction being done on a bank account as my project but the person i asked to help me told me that using flexcube all i need is to execute the code below it would create a table OUTMESG which my own code. …

Member Avatar for debasisdas
0
309
Member Avatar for yassar

I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare …

Member Avatar for yassar
0
4K
Member Avatar for vasantharajan n

can any of you help me by giving the project on library management system using VB6.0 and ORACLE 9i.... please friends... send me to email : <<Email Snipped>>

Member Avatar for vb5prgrmr
0
33
Member Avatar for andreski

Hi: Among the following technologies what you consider is the best tool for a developer to achieve more and best payed works? php - css - wordpress - .NET - ActionScript - ajax - android - asterisk - C# - c++ - css - Delphi - drupal - flash - …

Member Avatar for Salem
0
108
Member Avatar for curlyu@yahoo.co

i need your advice...please help me...my teacher ask me to create test bank using visual basic connected to oracle..but my knowledge is not enough to do it...can you give me some codes and advices in creating test bank?

Member Avatar for jwenting
-2
40

The End.