1,488 Topics
 | |
| | 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.