1,488 Topics
 | |
| | 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 all .. this jsp code when we use database access, to get the information by entering the price , my problem is that now iam using oracle as database and i dont know what are the changes that can be made here only ofcorse the path of database this … |
| | 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. |
| | I am using the code:- [B]strCon = "Driver={Microsoft ODBC for Oracle}; " & "SERVER= abc; uid=abc;pwd=abc;" Dim oCon As Object Set oCon = New ADODB.Connection Dim oRs As Object Set oRs = New ADODB.Recordset oCon.Open strCon[/B] while connecting this with installed oracle client it works but without oracle client it … |
| | helo i am working in oracle forms 10g. i am facing a problem may i create a grid control on form to display all data from a table. or how can i create a text item at runtime. thanks in anticipation. |
| | 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 |
| | Hello, I have to create a webapplication in ASP.net / C# with an Oracle Database in background. At first: I have no idea to do this! I read some things about ADO.net, DataSets, DataGrid and DataAdapter. But I think I don't got it completly. Now my responsible wants to display … |
| | 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. |
| | Hi all, can any one help me to solve the below query #!/bin/ksh #create or replace procedure a1 (a in number, b out varchar2) #is #begin --for testing purpose # b :='OKAY'; #end; $ORACLE_HOME/bin/sqlplus -s $userid << EOF set timing on set arraysize 5000 set serveroutput on size 1000000 exec … |
 | 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, …  |
The End.