1,135 Topics

Member Avatar for
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
201
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
398
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
498
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
76
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
187
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
252
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
163
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
50
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
85
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
51
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
47
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
96
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
788
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
66
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
79
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
55
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
73
Member Avatar for awo

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

0
52
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
279
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 halona

hi, I have objects called Customer_obj , phonecall_obj , then I have tables of these objects where there is a reference to the customer table inside the phonecall_obj table. I try to pass the customer object in a stored function to search in the phonecall tables about that specific customer …

0
79
Member Avatar for bankrupcyus
Member Avatar for sunil_ak47
Member Avatar for debasisdas
0
53
Member Avatar for freddyvf

how i can write query to show name of person who remitted maximum amount in a table

Member Avatar for debasisdas
0
69
Member Avatar for rledesma

I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number …

Member Avatar for rledesma
0
96
Member Avatar for chicago1985

I just loaded the 10g client EM on my Windows workstation to connect to our 10g database. Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had …

Member Avatar for jwenting
0
151
Member Avatar for rje7

I am trying to implement object inheritance with oracle 10g express. What i have done so far is created some types and subtypes. And some tables based on those types and sub types. So far i have understood that the subtypes inherit the attributes and methods from its super types. …

0
76
Member Avatar for samarudge

Does anyone know anything about Oracle Roles & privileges. An application on 9i has multiple roles assigned to each user. I am getting permissions problems, I think because there are conflicting privileges within the roles. EG: Role1 has SELECT, UPDATE on table1. Role2 has SELECT, INSERT on table1. User Default …

Member Avatar for debasisdas
0
87

The End.