1,488 Topics
 | |
| | 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 … |
| | have got this update script updating certain columns [CODE]update oppar set oppar_run_mode = 0, oppar_run_time = 0, oppar_interval_ind = 'N' , oppar_destination = '', oppar_run_date ='', oppar_run_interval='' where ( oppar_job_name, oppar_job_rec ) in ( ('CSCLM' , 'XYZ') , ('ARCLEVEXT' , 'LMN'));[/CODE] But there are cases where there is no record … |
| | Hi everyone, I am currently putting my skill set together and I am looking for a site (free) to host a sample of my Oracle 10g database work. I did some searches and I found this one [url]http://apex.oracle.com[/url]. Can anyone share his or her opinion on this site or can … |
| | I have created Following Function which takes 2 parameter [CODE] CREATE OR REPLACE FUNCTION Inst_Param_Desc(constant_Val IN varchar2(2), display_name1 IN varchar2(40)) RETURN VARCHAR2 IS Front_Display_Name VARCHAR2(40); Enum_Id number(4,0); BEGIN select b.enumeration_id into Enum_Id from xyz b where b.display_name = display_name1; SELECT a.front_end_display_name INTO Front_Display_Name from abc a where a.enumeration_id = Enum_Id … |
| | |
 | [ATTACH=RIGHT]16645[/ATTACH]Oracle announced Thursday evening (August 12) that they would be filing a lawsuit against Google, claiming that their Android phone software infringes upon patents and copyrights of their Java software, which they acquired when they purchased Sun Microsystems in January for $7.4 billion. "In developing Android, Google knowingly, directly and … |
| | i type the following code.... it runs properly....data gets fetch but i am not able to display it in a textbox.... it simply remains blank....whereas i am able to fetch the data outside the form tags here is my code: here i can see name =himanshu outside the form but …  |
| | Here is my java connectivity code to Oracle [CODE]public class OracleConnectivity { public Connection con; public Connection getConnection () { try { Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:dhanesh","dhanesh","root"); Statement s=con.createStatement(); s.executeUpdate("insert into test (num,txt) values (2,'hi')"); s.close(); con.close(); } catch(Exception e) { System.out.println("Connection failed"); e.printStackTrace(); } return con; } public static void main(String[] args) … |
| | need help here's code I'm almost finish I'm trying to find out how can i search down to the student who is taking at least two database classes here's the code [code] drop table student; create table student (student_id varchar(10) primary key not null, student_name varchar(10), major varchar(20), gpa decimal(10,1)); … |
| | I have installed microsoft visual basic 2008 express edition and oracle 11g express edition.. However when i try to add connection in the data connections from oracle, oracle does not appear... can someone help... Thanks. |
| | Is there a workaround to this as decode does not seem to allow the use of greater than equal sign I am trying to show the comment for any days beyond 4 days, not just 4 days. [CODE] decode(shipdate-orderdate,'4','This is unsatisfactory!') comments from orders [/CODE] Thanks in advance! :) |
 | Hi all, I am trying to implement Oracle autovue in asp.net or vb.net . If any one suggest how to use Oracle Autovue in asp.net or vb.net . If any document is provided in pdf or any link. thanks in advance |
| | Hi all, I am trying to implement Oracle autovue in my project . Can any one post any pdf file or any link regarding Oracle Autovue. thanks in advance. |
| | |
| | <prjt.ctl> [CODE] LOAD DATA INFILE 'F:\DataMining\dvdlist.csv' DISCARDFILE 'F:\Datamining\Discard\dvdlist.dis' INTO TABLE dvdlist FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS( DVD_Title char, Studio char, Released date "DD-MM-YYYY" NULLIF Released=BLANKS, Status char, Sound decimal external, Versions char, Price char, Rating char, Years char, Genre char, Aspect char, UPC integer external, …  |
| | I am using NetBeans 6.9 and Oracle 10g Express Database. All sql commands except insert are working fine. If I insert a value after connecting from the command line (conn HR/hr), the values are not reflected in Netbeans. The SQL Command line, Windows Command line and Oracle Home Page are … |
| | [B] I will do an artifical intellegent project which is knowledge base system My question is Can I use [COLOR="Red"]ORACLE[/COLOR] database as knowledge base?[/B] |
| | |
| | Hi All i am getting the below error pls help me to solve the issue datbase erre:ORA-20220: ORA-06502 PL/SQL: nemeric or value error: number precision too large in sp_watm_per_adj ORA-06512 at sp_watm_per_adj line 375 ORA-06512 at line 1 create or replace PROCEDURE sp_watm_per_adj ( in_per_adj_cd in per_adj.per_adj_cd%type, in_per_dt in per_adj.per_dt%type, … |
| | it always output this error: [CODE]Feb 07, 2012 11:25:32 AM org.hibernate.annotations.common.Version <clinit> INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final} Feb 07, 2012 11:25:32 AM org.hibernate.Version logVersion INFO: HHH000412: Hibernate Core {4.0.1.Final} Feb 07, 2012 11:25:32 AM org.hibernate.cfg.Environment <clinit> INFO: HHH000206: hibernate.properties not found Feb 07, 2012 11:25:32 AM org.hibernate.cfg.Environment buildBytecodeProvider INFO: … |
 | Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is … |
| | Hello all, I have a .zip file which is stored within a BLOB file. Using SQL Developer, how can I extract the .zip file from the BLOB in order to either open the file or store it on my local drive? I've never dealt with Zip files in BLOBS prior … |
| | I just tried to install IIg on my laptop. It seems to have worked, but there were issues. The program couldn't find several files during the install process, but still seems to have worked. What did not was the config part where it looked for a template file. I had … |
| | I have the following code for connecting to an Oracle DB [code] using Oracle.DataAccess.Client; // C# ODP.NET Oracle managed provider OraDb= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=ORCL) ) ) string oradb = "Data Source=//192.168.100.108;User Id=hr;Password=hr;"; // C# string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=hr;Password=hr;"; …  |
| | please convert this below query to plsql format select (select count(*) from cadastredefunct t where t.areacode= 'PTH01' AND T.SECTIONNUMBER = 'D' and t.defunctnumber <> 'ONGD') as total, (select count(*) from cadastredefunct t where t.areacode = 'PTH01' AND T.SECTIONNUMBER = 'D' and t.status = 'COMP' and t.defunctnumber <> 'ONGD') as completed, … |
 | Hello everybody, My question is simple. I wish to develop a web site and I have been looking for web hosts and most offer MySql. At my job we use oracle, but after some searching I haven't found any great differences between them and any real reasons why I should … |
| | I'm trying to create a table in oracle here's the code [code] drop table class; create table class (schedule_num integer primary key not null, semester varchar(10), course_name varchar(14), credit int, department varchar(15), /* meeting_time time,*/ meeting_place varchar(20), enrollment_limit int); [/code] I don't how to initiate the 'time' data-type, can someone … |
| | i want to find records between two dates IN ORCALE but the table field values is in "mm/dd/yy hh:mm::ss" and data type is varchar2 The query which i was trying was: [CODE] SELECT * FROM NEW_OUTPUT_UPLOAD_TSN WHERE OUTPUT_UPLOAD_DATE BETWEEN TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') AND TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') [/CODE] |
| | Hi I just installed Oracle 11g R2 on my Win 7 Ultimate x86 machine in compatibility mode (XP SP3). It showed that the setup completed successfully (without a single error & warning, I got few when I ran it in Win 7 without compatibility mode enabled.). Now I am trying …  |
| | Hi, I installed wamp server and oracle 9i ,both are running . Oracle having user id,password and host string , using these how can I connect to retrieve data from Oracle ? thanks in advance , very urgent Subrata  |
| | Hi, I'm having a data base which looks like this patient(pk_id)--(fk_pat)appointment(fk_doc)--(pk_id)doctor(fk_spe)---(pk_id)specialty The goal is to select all the patients which had an appointment with a doctor with 'dentist' speciality. I made 2 requests, one is correct and the other is incorrect correct one: [CODE] select distinct patient.name from pataient, appointment, … |
The End.