2,627 Topics
 | |
| | 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 … |
| | Environment: Visual Studio 2010, Windows Forms Application, Oracle Database I am trying to use a parameter in a DataSet.xsd DataTable. The query and parameter work fine in Query Builder but gives an error if I try "Preview Data" or use in my application. Error: An unhandled exception of type 'System.Data.OleDb.OleDbException' … |
| | I know alot of you guys get the same posts over and over about intro JavaII Classes, but I have tried to refrain from asking something that has already been solved and try learning on my own, but Im stumped. Im having trouble with this program, specifically at my calculation …  |
| | |
 | [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 … |
| | Proper way of doing this? Please disregard some variables. [CODE]Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class Addcage Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private cb As OracleCommandBuilder Private ds As DataSet Dim roomprice As Integer Dim roomtitle As String Dim lubid As String = …  |
| | Alright, so I tried to write a little short guide on Object Input and Output to files, since the worst situation one can find themselves is being unable to serialize files in a proper and readable format. One way to do so is to create an object of a class … |
| | 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. |
| | I have a question programmer's... we know that in Visual Studio...you can open a different kind of database... like: Access, SQL server or file, Oracle... is there any reference that you'v know on how to make that kind of program?? i don't know where to start... VB.NET codes please..... TIA! … |
 | The biggest heroes and villains in IT history have been revealed as the results of a new poll are published. Perhaps rather surprisingly, Steve Jobs is just as hated as Bill Gates and Facebook founder Mark Zuckerberg is more hated than both of them. But that's just where the shock … |
| | 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. |
| | |
| | Hi; This is a code that I got from the examples in Oracle in using the javax.print When i try to compile and run a get an error saying javax.print.PrintException: java.lang.IllegalArgumentException: URI is not hierarchical [CODE]package printtry; /* * Copyright 2001 Sun Microsystems, Inc. All Rights Reserved. * * This … |
| | i want to install backtrack 5 r1 i downloaded iso format from their website i load it with oracle vmware (virtual machine in order to install it ) i run install on back track 5 screen after that passing through time selection and keyboard setup i come to partion manger … |
| | Hi, I have an c# application works with oracle database communicates through java web service. In windows XP it works fine with calendar, but with Windows Server 2008 R2 Service Pack 1 it does not work instead it shows some error(the same application is used in both the environment). I … |
| | <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, …  |
| | Hello, How can I do a login form in jsp using oc4j server. (oracle jdeveloper). Assume I have this page. [CODE] <HTML> <HEAD> <TITLE>Login into the Employee Records Center</TITLE> </HEAD> <BODY> <H1><CENTER>Login into the Employee Records Center</CENTER></H1> <FORM NAME="LoginForm" ACTION="index.jsp" METHOD="post" ENCODE="application/x-www-form-urlencoded"> <P>To login to the Employee Records Center, submit …  |
| | 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] |
| | I was using Struts 2 as web framework and eclipse EE as my IDE. I can run my jsp/servlet application just like the way i wanted it to be but everytime i start the tomcat ver 6 server, an INFO log always appear except that its asking for log4j. here … |
| | |
| | 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 problem with my interface,i want to I want when I hit the button, the progress bar goes off, so I have not found where is the problem in my code is that any one can help me and thank you. import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JProgressBar; … |
 | 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;"; …  |
| | Dear all helper In recently, I found that my computer CPU usage always 100% usage and I notice that it cause by ping.exe in the process list. When I kill the ping.exe process, my CPU usage is go down well. But after a few seconds, the ping.exe run again and … |
| | 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, … |
| | Hello. I've got an exaple data base for hr account from Oracle. My goal is to create a view which contains empno,ename and deptno from EMP, but than i can only add rows with condition deptno=20. I've cameup with [CODE] create or replace view d20emp as select empno as num, … |
| | Hi, I am developing an website in wampserver which was working fine but when I installed Oracle 9i ,Oracle working but wamp server sopped .I edited the httpd.conf as follows : chaged port no "Listen 80" to "#Listen 12.34.56.78:8080 Listen 8080" and restarted wamp server but didn't work then I …  |
| | Good Morning, I need some example with SQL plus code on various SET operation. But the query have to be with SELECT keyword. For example I am giving a code: [CODE]Create table student (s_id number(4), sname varchar2(10),constraint pk_sid primary key (s_id),blood_gp varchar2(4)); create table location(l_id number(4),location varchar2(20),constraint pk_lid primary key(l_id)); …  |
| | Hellow. I have 3 variables 1. string query; 2. public static OracleCommand oracmd; 3. public static OracleDataReader reader; I have used these variables in a function [CODE=C#] . . . public void PreviousValue() { query = " select * from....... "; oracmd = new OracleCommand(); .... .... reader = oracmd.ExecuteReader(); … |
| | How should I use SQL loader to load a .csv file as an Oracle Database ? [CODE] CREATE TABLE products( ProductID INTEGER NOT NULL, ProductName CHAR(30) NOT NULL, SupplierID INTEGER, CategoryID INTEGER, QuantityPerUnit CHAR(30) NOT NULL, UnitPrice INTEGER NOT NULL, UnitsInStock INTEGER NOT NULL, UnitsOnOrder INTEGER NOT NULL, ReorderLevel INTEGER … |
The End.