2,627 Topics
 | |
| | Hi Friends, I'm new to daniweb as well as to the world of programming. I'm creating one project using visual basic 2008 and oracle 10g. Now I want to create some reports using crystal report. But when I run the report. No data comes up. Only the heading. Can any … |
| | i dont know how to post a question so that, i can create my question in this link... my question is all about how to create an oracle code database in vb6, im a student and beginner programmer... |
| | [B]Now playing:[/B] AC/DC Black Ice [B]Now reading:[/B] Wikinomics [B]Now browsing:[/B] Fedora 9/Firefox 3.0.2/Gnome [B]Editors/IDES/tools used today:[/B] Vi, Gedit, Emacs, Bluefish, Visual Studio (BizTalk), Notepad, DBVisualizer 6.1, Xlint, xsltproc, Microsoft SQL Server Management Studio [B]Languages used today:[/B] TSQL, Bash, XSLT, XML, pgsql [B]Operating systems used today:[/B] Windows 2003 (64/32 bit), RHEL … |
 | Ok, so I'm learning about procedures and functions in Oracle and I'm stuck here with my procedure. I have the function part down pretty good, but the whole returning variables with procedures through OUT mode is confusing me. My task is this: "Write a procedure that accepts a zipcode & …  |
| | |
| | hi i am creating stored procedure using cursors, i am using two cursors in my procedure, i takes the two fields in one table that fields are stored first cursor, and second table fields are stored in second cursor, and i check the condition for first table one field is … |
| | hello, everybody I m final year computer engineering student.I m very much interested in DBMS,java, and all programming stuffs.I have to do a project on DB and java... programming if required,... can u pls suggest some topics and give me resources i need to have(like mysqlor oracle 9i,vb .. etc.etc..)to …  |
| | Hi friends, Please send me the process of connecting and accessing database to Ms Access/Oracel . Pardeep |
| | hi please give me idea for how to avoid duplicate key in a table thanks |
| | Hi friends, I m creating a software with backend of ORACLE 9i. I need to Generate backup ORACLE "ADDFILDP" table to ACCESS "ADDFILDP" table(Simply Copy the data to one table to another[ORACLE to ACCESS Table]):$ An access File is already Created. I was code for it as Follows [ICODE] Private … |
| | Currently I am working on one form development using Java. In JSP page I retrieved the data from table using F9 keys i.e for any input field variable available in JSP page, once I pressed the F9 key, all the related data is displayed in the popup window. Once I … |
| | HI , I want to develop a new site whcih should store videos, images and docs.. What is the best method ? store this in database or as external file in disc ? Could you please point out pros and cons of both As performance is my main concern for … |
| | hi..I'm just a newbie when it comes to oracle and I would like to ask for some help. I just would like to ask if how do i put in my menus in my forms? I cant seem to solve this problem. what property in the property pallet should I … |
| | I am thinking of going with ColdFusion Enterprise over my current PHP. We do alot of web apps working with MySQL and Oracle. I have no problem paying for it compared with free PHP because I hear that ColdFusion can cut down my development and debugging time. It also seems … |
| | I need to add in my forms ability to upload and download files in any extension (or if it is not possible it can be PDF only) i build upload .jsp and .html to upload so i have file name and path of it in table So my question is … |
| | please i need help on how to install oracle 10g on redhat linux which is a guest operating system on my computer. windows xp is the host operating system thanks a lot anybody cheers |
| | sorry if this is a dumb FAQ type question, but i have been searching all morning for a answer. Heres the setup. I have an Oracle 10g DB outputting Relational Tables into XML. heres an example out some output. [code]<?xml version = '1.0' encoding="ISO-8859-1"?> <?xml-stylesheet href="blog.xsl" type="text/xsl"?> <ROWSET> <ROW num="1"> … |
| | I will pay 50$ over PayPal if you solve this problem for me. Post here if you are interested or email me at <EMAIL SNIPPED> I will provide the .sql file with the database Guidelines: -UPPER CASE for all SQL reserved words, and Mixed or Lower Cases for names you … |
 | Hi Everyone, Is it possible for a table in MySQL to be updated on a regular basis from an Oracle database? |
| | I just started learning php and mySQL, if i want to create 2 tables, how do i connect them with a foreign key? In oracle, it is something like below, would any one point out what have to change to make it work in mySQL? phpMyadmin GUI doesn't seem like … |
| | Plz Help! We have installed Oracle 10g successfully but the problem is that after launching Oracle from Start--->All Programs------->Oracle-------->Database Control-DB Name a login Screen comes up. This login screen is coming up.However inserting user name and password and clicking on Login button ,the next screen does not appear. I have … |
| | hi how to convert timestamps to date in oracle, and please give me example sql statements help me thanks bala |
| | I have installed oracle client 10.2g and I have used it with MS visual studio for a few days and it worked just fine. Yesterday I started to receive this message whenever I try to log in into 'localhost' [CODE] System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. [/CODE] … |
| | |
| | I tried to use CF_SQL_ARRAY in the following but it is not working: ColdFusion: [code=coldfusion]<cfset faq = ArrayNew(1)> <cfset ArrayAppend(faq, "What are ColdFusion arrays")> <cfset ArrayAppend(faq, "How to create a ColdFusion array?")> <cfset ArrayAppend(faq, "What are two dimensional arrays?")> <cfoutput>#faq[2]#</cfoutput> <cfstoredproc procedure="p_cf_array" datasource="#Application.DSN_VAT#" username="vacdvl01" password="vacl33ds" debug="Yes"> <cfprocparam type="In" cfsqltype="CF_SQL_ARRAY" dbvarname="array_in" … |
| | Hello dere! I am a maybe I.T., MSc from AIU, LA. Taught compter subjects MS apps, Oracle, basic C. Wanted to be a programmer, got the schooling, but never the skill. I am 61. I like to write. I am from Chicago, living in Long Beach, CA. In a nutshell.  |
| | Hi I hava a small application on oracles forms 6i and I run it over windows terminal service I am looking for an easy way to translate from forms to PHP does anyone knows any tool for this purpose?? thanks in advance |
| | Hi there Sorry if i have posted this on the wrong area. I have a problem with a simple query shown below [code=sql] SELECT * FROM Disney WHERE Upper(COLNAME) LIKE UPPER('%' || SEARCHSTRING || '%'); [/code] My problem, The colname variable is not being recognised as a column name for … |
| | Im doing an application that runs on vb.net using oracle database. The function that i did is to select 3 combo boxes for the information to come out. The problem is i can only retrieve the records from the first selectedindex=0 of the ifelse statement and not from the others. … |
| | [code=sql]SELECT NetAmout FROM MONTHLYBILLS WHERE REGNO = '047080809' AND TRUNC(BILLDATE) BETWEEN '01-AUG-2008' AND '30-AUG-2008' [/code] In above Query written 4 rows in which 3 rows showing netamount 0 and last 4 row showing netamout 4200. [code=sql]SELECT DECODE( SIGN(SUM(NETAMOUNT)),0,0) FROM ALMONTHLYBILLS WHERE NETAMOUNT NOT IN (SELECT DECODE( SIGN(SUM(NETAMOUNT)),1,0) FROM MONTHLYBILLS ))[/code] … |
| | Hi! I started to study Oracle a few days ago and I felt the need of Oracle Database Application. So I entered the Oracle web site and tried to download the given link for download However, then I was requested to submit my "Single Sign-on" User and Password. Moreover, I … |
| | please anybody tell me the query to transfer some amount of money from one account to another account. |
| | |
| | here is my dilemma I have an Oracle database that consists of tables (duh!) for an award nomination project where I have a table for nominees and a table for each category of qualifications for example table 1 (nominees) name ID_NUMBER PK DEPARTMENT NAME PHONE# table 2 (education_information) ID_NUMBER FK …  |
| | [B]hullo friends, am a little new in the field of VB and currently i have created a login and registration form i nkow how to connect to oracle but i need some code to help me register new users and post them to the oracle database and login form should … |
| | Why is it that a connection cannot be created in my computer in Oracle SQL developer 1.5.1? I have given the correct host name of my system. Still it says that the connection has failed. Since I am new to Oracle and SQL, I cant seem t find out how … |
| | |
 | Hello Everyone, I am having some trouble with a VBA application I am writing for work. I am using ADODB to connect to an Oracle database and return and I want to return a 2-D array from my function. The problem I am having seems to be determining how big … |
| | In my oracle, there is a table : locations( city varchar2(10), country varchar2(10)); executing the following script results the desired column. [code=php]<?php $link = oci_connect('SYSTEM', 'abracdabra', 'orcl'); $s = oci_parse($link, 'select city from locations'); if(! $s) { $e = oci_error(); var_dump($e ); } oci_execute($s); $res = oci_fetch_row($s); while($res) { echo … |
| | i am using oracle 10g along with php 5. the problem is i cannot connect with oracle database from php with the function oci_connect. i can understand that this is because of the way php is configured. can anyone help me configure php to connect and manipulate oracle database? |
| | Hi Friends, can some body help me in designing the below scenario: MY QUESTION IS HOW WOULD THIS INTERFACE LOOK LIKE? Objective: To design an interface for the following scenario. See attached image for visualization. Scenario: 1. There is an Application X (May be a VB or Java application) and … |
| | Just wanted to say hello. I live in Sugar Hill, Georgia (USA). I have about 15 years of IT experience in the areas of Project Management, Technical Support and Database Management. I have formal training and certifications from/in Oracle, Microsoft, CIW, Sun Microsystems, Dale Carnagie and CompTIA. With all that … |
| | Hey Folks - We need your help. We were hoping, we could gain from your experience with implementing server virtualization. When should we be using Red Hat Virtualization, Citrix Virtualization, Xen Virtualization, Microsoft Virtualization, Oracle Virtualization and VMWare. I will be very interested in learning from your first hand experience. … |
| | [code]con.BeginTrans con.Execute "insert into A3 values(1,'B')",cnt1 con.Execute "insert into A3 (id3) values(1)",cnt2 con.CommitTrans[/code] if second statement fails to execute then it should rollback the transcaction. Here, I want to check whether any transaction is still in process and error has come. If this is the case then will rollback transaction. … |
| | I have this kind of query: [code=sql]select (s.t1 + s.t2 + s.t3 + s.t4 + s.t5 + s.t6 + s.t7) total from summary s[/code] is there a way that i could shorten the formula? my table fields are growing and i need to include them in getting the total for …  |
| | Hello All. I am currently working on a project which basically makes splash screens for plasma displays. Details on objects are stored in an Oracle database accessed using ASP.NET and requested using AJAX. I have already got a working version of this project which people are happy with but I … |
| | This is the error what i get when i try to run my project: [CODE]Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/varad1 Error Code: 0 at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:305) at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:102) at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource (DatasourceLogin.java:184) at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource (DatabaseSessionImpl.java:582) … |
| | Hello Guys, I am new to VB6 & Oracle too. I have one got one Project from my friend. He gave me some VB6 files & 2 SQL files for Oracle database. Now i want to know that how can i connect my VB files to database?? I am also …  |
 | I've developed a software using VB6 and MSSQL 7.0. Now I need to create a backup-restore program on behalf of my software. For this I need to fetch down all the table names located inside the database used in the software. My database name is -->BILLING_SYSTEM and I've also created … |
| | Please help me out to find the actual size of the table . i have used two methods one is (num_rows*avg_row_len)/1024 . other one vsize(columns1) (for each column in table). but both the methods are not giving me the right answer help me if u know actual method to find … |
The End.