1,488 Topics
 | |
| | 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 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 … |
| | 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? |
| | 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" … |
| | 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 … |
| | [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. |
| | |
| | [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 … |
| | |
| | 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 … |
| | [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 …  |
| | 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 … |
| | I need to export 20 small records from one table in Oracle 9i into an xml file. Each record has 4 fields. Please advise if I can do that and what the command would be in sql plus. |
| | |
| | I'm doing an internship, and my managers require me to create a form using Oracle WebForms. What I don't get is that when I searched Oracle's website, I can't find much information about Oracle WebForms, but I can find a lot of information about Oracle Forms. And when I played … |
| | Hi friends, I know process of connectivity to oracle but i have a problem whenever i restart my computer it shows ORACLE NOT AVAILABLE . How can i avoid this disconnection error. Please help me.  |
 | hi friends.. i'm studying mca(5th sem).. this sem we've a middleware project which connects 3 different databases.. yet now i used only one database.. so i dont know how to give datbase link.. i've googled.. but none has explain that clearly(not upto my satisfaction)!! can anyone give an idea how … |
| | Well Friends, I am thinking to get Oracle Global certification OCA. For this, I need to get some good ebooks of the oracle press,can anyone here can provide me the link? Thanks in advance. |
The End.