2,359 Topics
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 …
hi i have two tables,in the first table i want 4 field and second table i want one field, i want calculate sum function in the firsttable using group by clause in the second tablefield, how to calculate please help me
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 …
[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 …
Hi! I have created a web form with HTML and ASP (separate but same idea). What I want is that this form will be autofilled with data from Excel spreadsheet or alternatively from ATC! that is an SQL database. Our customers will receive a link to this form and when …
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 …
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 …
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 …
I am a newbie as in Johny NC. I'd love to get connected to people at my own level of experience or above it in IT so we can learn from each other. I'm a guy from Nigeria and I like to relate with people who have a high need …
I am a newbie as in Johny NC. I'd love to get connected to people at my own level of experience or above it in IT so we can learn from each other. I'm a guy from Nigeria and I like to relate with people who have a high need …
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.
Hello, I am new to JSP. I would like to learn how to create a JSF application that has a table within and the user can add items to the table , update existing items or remove items. I am working with an Oracle database. I will be happy to …
please help me.. m in final year MCA student.. i have to do a project on c-quiz application in Java[/U][/B] as front end and Oracle as back end.. if anyone can send me the source codes to <email snipped>
Hi.. please help me.. i dont know much about java.. but i have to do a project Order processing System in java and oracle.. This project is only for shop keeper its not online.. It shoul have two categories 1)Order procsesing where it should take orders from customer for a …
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.
Please can somebody tell me the difference between web development and web programming.
Hi ALL, I want to print some lines from file like example ===== RECOVER DATABASE ALTER DATABASE OPEN; ALTER TABLESPACE TEMP ADD ALTER TABLESPACE TEMP ADD STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE -- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 16 MAXLOGMEMBERS 5 MAXDATAFILES 512 MAXINSTANCES 1 MAXLOGHISTORY 7260 LOGFILE I …
Hi all, i m having a problem with inserting data in oracle db. When i use form action =(call self page) then data is inserting properly.But problem with when using form action=(Another_page).data is not insering into database.For ur kind infromation i m using oracle db and php for my application. …
Hi everyone, Is it possible to create a Microsoft Word macro that will open up a VB GUI that will have a number of form fields. Once you fill out the forms, then the macro will use that information to query an Oracle database and then return the formatted results …
Hey all, I have a weird query and I'll try to explain it simply. I am building an application inventory for my work. The database includes a single master table (tb1) and many slave tables. Some of the slave tables have a language code on them (so it can store …
hello everyone, I am having a problem with populating second a drop down list depending on selected value of first drop down list. I have been searching the net for the last couple of days i found php with mysql and but couldn't find anything for oracle + php. in …
Hi everyone, I need some suggestion. Actually i created a text box and wrote a java script to limit its character hold to 500 char. I made my related db column size to 508bytes(Oracle). The functionality was working fine when i suddenly found a bug. Say for example if i …
First off Im not a dba and Im fairly new to sql. These questions are probably basic SQL knowledge but here are the questions: 1. Say there are 75 million records in the database with about 100 columns. If you run a simple SELECT query with a couple where clauses, …
Does anyone know how to change the look of the java files that are listed when you expand the java folder in the tree structure of the database? i have these numbers infront of the class file, but have no clue what they are, they are not there in toad(i …
I am stuck between deciding between MySql and Oracle, The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not. Any views on …
Hi, after spending days on this I hope someone can help me. I am using one gridview nested inside another, and I need to reference on of the columns in the adult gridview when updating the child gridview. Make any sense?? I have a footer row in the child which …
I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it UPDATE sal SET sal= sal+3000 select * from .................. insert into table tab_name values(........) insert into table tab_name values(........) insert into table tab_name values(........) .........so on Is there any SQL query like that if …
how to convert jtextfield into appropriate form of string and store it in JDBC of oracle software I am trying to read string from JTextField and convert it into string and store it in oracle database
Hey guys, can someone please tell me how I can connect to a remote Oracle DB using WAMP (Windows Apache MySQL PHP) installed locally on my machine?
what is a database driver (such as microsoft provider) and a database provider(such as jdbc driver , odbc driver , dbole driver) and what the importance of each of them?
Hi, I am a junior dev. and I need help on some select statements on a Oracle db. First I needed to get all the months of the year in 'MON' format and I did it like this: [code=sql]SELECT distinct TO_CHAR(dt,'MON') MONTH FROM ( SELECT TRUNC(SYSDATE,'y')-1+ROWNUM dt FROM all_objects WHERE …
Hello All, I came across with the following case and I would like to share it with you to get your opinions about. In vb.net I use data from tables (oracle db) and i want to check two columns. Both columns have name of customers. All I want is to …
Is oracle 9i server , still good enough for todays applications, are there any new features that are worth considering in the latest versions???
Hi, I am new to web development, and have got myself stuck when trying to show totals in the footer of a gridview. I am building my grid from an oracle DB, and have the used the code below to generate my totals. By using debugs I can see that …
The End.