1,488 Topics
 | |
| | can any one help me out i want to make an application using oracle . i want to know evrything from scratch. plzzz tel me i am so eager to make it[COLOR="Red"][/COLOR] |
| | Hi, I have following table structures. # Table1 # link - varchar hlink - varchar top-cap - varchar (FK) sub-cap - varchar (FK) lk - varchar(PK) # Table 2 # cap - varchar(PK) caps - varchar captype - varchar top cap and sub-cap in Table1 are FK. They refer cap … |
| | Whenever I tried to access Oracle DB from PHP , it shows error Everything is ok, Path is okay. I changed php.ini file to. I am using old version of xampp Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the … |
| | Can anyone explain me RR DATE FORMAT in Oracle, its getting pretty confusing for me. Appreciate your time and effort. |
| | I have installed oracle10g but I cannot find any java sample programs for data mining! I could not find any download link on the internet! Please help! |
| | Hi, can you help me please, i have to build a query and i have a problem in the group by expression ==> error message: not a group by expression my query: select ress.nom nom_ress, task.nom tache, max(tr.entrydate), ass.prstart, ass.prfinish, nvl(ass.practsum,0) service_fait, nvl(ass.prestsum,0) service_à_faire, prj.nom projet, tr.resource_class, tr.transclass, tr.project_department from …  |
| | Hi, I am trying to return a ref cursor from a stored function but I keep getting this error message 'Specified argument was out of range of valid values'. The reference cursor does point to correct data, I used a anonymous block in oracle to test it out. How can … |
| | Oracle query to display all policies existing in the database? Can anyone tell me what will be the "Oracle Query to display all policies existing in the database"? |
| | Hi Guys, I have a table in Oracle with a column userid and i have a userid column in Active Directory. based on this i want to query the Network ID and update in one of the Group in the Active Directory. Can you guys help me on how to …  |
 | # EER for Rental store, to be put into Oracle for a database. # I have a databases project due monday. I'm still very new to databases so my understanding is minimal. I'm sorry if the answer to this is already on the web or somewhere on daniweb but I … |
| | Hi guys, I have the following problem select a.id, a.start_date, a.end_date, b.start_date, b.end_date from interval_1 a, interval_2 b where a.id = b.parent_id This will generate a solution like: 5 | 01-Apr-2012 08:30:00 | 01-Apr-2012 12:00:00 | 01-Apr-2012 09:30:00 | 01-Apr-2012 10:00:00 5 | 01-Apr-2012 08:30:00 | 01-Apr-2012 12:00:00 | 01-Apr-2012 … |
| | #**Can anyone please tell what are the differences between Microsoft Access and traditional DBMSes (i.e. SQL Server, Oracle, Postgres, and MySQL) in reference to how they handle record-locking, rollbacks, and database updates? **# |
| | guys - i cannot figure this one out. i keep getting the "wrong number or types of arguments in call" error & for the life of me can't figure out why. i've got dozens of other programs doing way more difficult stuff than this so, i'm officially stumped. 4 parameters … |
| | Hello I am trying to write a select statement that will compute the average room rate under the assumption that if the room rate is "null" it should be replaced by the minimum room rate from the table. The following is all the details of my table : create table … |
| | Hello All, i am new to oracle , i need to know where to start (books , videos , tutorials) where to start from scratch Thanks a lot.  |
| | m trying to connect my project wid oracle db ..wts wrong wid dis code yr....:( <%@page import="java.sql.ResultSet"%> <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@ page import ="java.io.*"%> <%@ page import ="javax.servlet.*"%> <%@ page import ="javax.servlet.http.*"%> <%@ page import ="java.sql.*"%> <%@ page import="java.sql.*" %> <html> <head> <title>db</title> </head> <body> <% try{ System.out.println("hi"); Class.forName("oracle.jdbc.OracleDriver"); Connection …  |
| | Hi Iam admin for Redhat, my client requested to install oracle 10g in RHEL5 i downloaded packages how do i proceed the further steps. please guide me. |
 | Hi. After many years of having a hobbyist interest in programming but doing other things for a job, I've decided it might be time to attempt a career change to application development. The other areas I've worked in, such as teaching English to non - native speakers, aren't directly relevant … |
| | Hello, I'm doing a simple J2EE application that will interact with a database like Oracle and you know that a database can have multiple oracle schemas and that is the problem (because I do not know how to configure hibernat with multiple schemas :( because my application can handle multiple … |
| | Hello every one, I have a question about creating users in Oracle using SQL*PLUS. But what I want to do is write the syntax in a txt file first (script) then when I run the script by calling it using the @ or by copy/past it should prompt me for … |
| | Can Anyone tell how to convert String datatype 2 timestamp using altercommand in oracle  |
| | hi frends i m in fifth semester of engg in info.tech and i need info abt projects of database particularly hospital and railway reservation management pls send me informatuion from where i can get these projects and front end of projecs shuld be in visual basics VB |
| | I am trying to create a table with a multikey but given i have to create a trigger and a sequence to place an auto increment key i am having difficulties on how to set a foreign key to be attached to a multi key. any help will be appreciated |
| | Hi i have created oracle database with 100 tables. Now i want to replicate the same data, indexes,triggers and everything into sql server2008 without using any third party tool and scripts.I should use either Query or C# code. Can u please help me to get a good solution? Bunch of …  |
| | hello iam started taking oracle 10g i have few doubts please clear me for example create table employee (ename varchar2(10),salary number(7,2)); what is the use of varchar compared to character??? what is number(7,2) i mean 7,2 i dont understand please explain me |
| | Hello, I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? Could anyone list out the steps that should be performed. I saw the concept of … |
| | I am facing problem in database. i want to select tables which have been updated from last one week.. |
| | Any commands for creating database using oracle command? as well as creating tables? I have this in creating table but did not work. Having invalid table name error. [CODE] Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class dump Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private …  |
 | ORA-01000: maximum open cursors exceeded tips I am getting following error. I made a combo box with select query behind it, i used itemlistener to fetch data. Today during testing i found that if user move too quickly in combo box so select query will be fired for each number … |
| | hello there, i am new to oracle. i am trying to load different database, which i have just created using database configuration assistant in oracle, called "mydb". i want to load it when scott user logs in. btw which database loads when scott logs in, is it orcl or something … |
The End.