[oracle] Forum Topics

Hellllo everyone I am looking for a tool to volume test my web application...my app has to connect to an Oracle DB so preferably I would like something to simulate enough traffic to max out my connections. Does anybody know of/already have a preference for a web stress tool? Thanks!!! …

hi, i'm a final year engg. student of MU. I require a mini project based on SQL related to real system scenarios. PLZ HELP!!!!!!

please forms from oracle with php insert,delete,search ya tengo el formulario de mostrar registros[ select ] ..... Alguna persona que tenga formularios ya mencionados que lo comparta para ver como va el codigo en esos formularios ......... muchas gracias por su atencion .........

I am using oracle query in that four fields are number. I am subtracting that field such as (field1 - field2 -field3 - field4) as DNF Actually I am creating query in view. While creating this view the last field DNF is created as varchar2(40) automatically. I am using this …

i have the following query SELECT C.FIELD6 ,C.FIELD2,C.TRANSACTIONNO FROM ipfroutine_deduction a,Servicemaster B,INPATIENTBILLALLDETAILS C, Departments D,INPATIENTBILLS E WHERE a.ipftestcd=b.code AND C.BILLNO=E.BILLNO and trim(a.ipftestname)=trim(b.childname) AND TRIM(B.childname)=TRIM(C.FIELD2) AND TRIM(A.IPFDEPTCD)=TRIM(C.DEPTCD) AND TRIM(C.DEPTDESCR)=TRIM(D.NAME) AND E.FROMDATE BETWEEN TRUNC(A.IPFFROMDATE) AND NVL(TRUNC(A.IPFTODATE),E.FROMDATE) AND C.BILLNO = 'D00024585' It's result as NO FIELD6 FIELD2 TRANSACTINO 1 220 CHG (HB TC …

hi myself piyush me too has to design a project using VB and DBMS plz suggest me topics

Hi, I am having problems starting Oracle [URL="http://www.linuxforums.org/forum/#"]Database[/URL] 10g Express Edition on Fedora. Here is what I did in order to start it: [root@x1-6-00-c0-9f-bb-ba-57 ~]# /etc/init.d/oracle-xe start [root@x1-6-00-c0-9f-bb-ba-57 ~]# xhost + access control disabled, clients can connect from any host Not sure what I am doing wrong here. Help would …

My query is below. I need to evaulate each row returned (and provide a "label" - shown with an astrick) based on the values in the 3 date columns and I'm stumped as to how to do it. Here are my conditions and labels: Action_Dt = Effdt AND Action_Dt < …

what are the differences between 9i , 10 g , 11i . for what purpose these will be used. Somebody told me 11i is developer suite and 10g is database. i don't know what is this oracle developer suite.plz somebody tell me clear difference between these.

Hi. In Toad, I can select a user/role, right click, and select "Create script", and it creates a SQL script of the user/role definition. I find this handy if I only want the user/role definition and not want to export/import any data. Does anyone know how to obtain/create/export a user/role …

I have a school problem, I'm not going to try and hide it. This is for Oracle9i: [URL="http://www.daniweb.com/techtalkforums/thread70629.html#"]SQL[/URL] class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. …

I'm not entirely sure If this is going in the correct location. What I want is to set up my database so that it will updated every hour. I'm a little unsure on how to tackle this problem. Does oracle actually support this type of updating, and if not, would …

i have to call a stored procedure that shoud return all data in a table. so how to create procedure and how to return data from procedure. kindly send me a small example program .........

Recently I made a java servelet program that interacts with the oracle database n performs just the basic operations of data addition and retrieval. My problem is that I want the data to be stored in an encrypted format also can encryption of bitmap files in the database is also …

I am using MS Access 2003 to link to an Oracle 10g table utilizing Oracles 10g ODBC driver. When I view the data everything is fine except for the datetime field (which is also an index on the Oracle side). Access shows a value of "OLE object" in this column …

Can anyone of you provide me the code for emailing in oracle with a .csv file as attachment.... i have already tried out sending email in oracle and succeeded but the need is for sending an email with a .csv file as an attachment Please do provide me a quick …

Here's my code...basically, I hard coded yesterday just to make sure it works...Im trying to get it to display results everyday [code=java] String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" + " WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID …

HI here is the code which gets the error message "ERROR OCOURED-29279->ORA-29279: SMTP permanent error: 500 Access Denied By Port Acces" please do help me in this regards thanks in advance CREATE OR REPLACE PROCEDURE s_test AS l_name VARCHAR2 (1000) := ''; conn UTL_SMTP.connection; send_from VARCHAR2 (1000) := 'aldrin.vas@hotmail.com'; send_to …

Hi, I want to increase number of processes in oracle 10G. What are the other parameters needs change for increasing number of processes ? In web application, it give TNS connection failure... regards, -hiren

Does anybody know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates.

Hello, everyone. I am going to develop an oracle project using oracle database for back end and oracle forms for front end. The oracle software that I am using to develop this project is Oracle9i. Can any of you recommend a website that provide Oracle Form tutorial? Thank you :)

I am using Oracle9i for my applications.I want to write my data onto different Hard Drive. Can AnyOne help me oon this...

hi, how to export a table from sql*plus to an secondary memory like cd ,floppy or hard disk. I challeneged with my friend I will tell u in a week. if anybody knows please give the commands and what i need to do after creating a table in sql*plus. I …

Hi, I want a variable table name in a procedure. I thought some IN parameters can be passed like procedure may receive a varchar table name or a number deciding which table to use for fetching data. is it possible? Waiting for reply. Thanks in advance.

hello... i have a little problem about how to create an auto-increment process. i'm using an oracle and all the table and data is already exist in my database. I have seen a few example from internet and it is like this. [B][COLOR=green]table users {[/COLOR][/B] [B][COLOR=green]id int(13) not null auto_increment,[/COLOR][/B] …

Hey guys, im in deep need of help for [URL="http://www.daniweb.com/techtalkforums/thread78156.html#"]mysql[/URL]. Ive been given a few questions most of them answered although theres 3 which are really bringing me down. I was wondering if u could get some help :D Given this schema borrow([U]transactionID[/U], personID*, borrowdate, duedate, returndate) author([U]authorID[/U], firstname, middlename, …

can Any one Help me please!! How to make a Procedure can send email with attachment ? thx

Hi, I need to Pass XML File as Parameter to SP and read it and store the tag value in variables. Any example for the same is preferred. Thanks

Hi, How to check if BLOB field is NULL or Not in a Table though other data is available in a selected row ? I need to do this in a sql statement. Thanks Sandy

What is the limit on how many records you can have in a table in Oracle? It must have a limit. Also, has anyone ever benchmarked Oracle on sorting records... say 1,000,000 records of a small record size, just 2 or 3 fields? :cheesy: