2,627 Topics
 | |
| | A certain multinational company (provides coverage of sporting events like olympics) has decided to acquire a system that will definitely provide big benefits to them in terms of its operations. In relation to this, other software products valuable to the business have also been procured upon the recommendation of technical … |
| | 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 … |
 | After spending some time on JSP section of this forum as many before me, I come to the conclusion that we are in need of "proper" tutorial on this topic. This tutorial is not intended to teach you everything from top to bottom, it is just a starting point to … |
 | 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 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 … |
 | |
| | Hi, I had Redhat Enterprise Advance Server 4 on my PC with partition, I have Windows XP and also Linux. I could browse internet on both OS. As I could not install Oracle 10G on Linux, I have upgraded my Redhat Linux to Oracle Enterprise Linux. Now I cannot browse … |
| | 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 … |
| | what is wrong in following code [code] <form name="log" method="post" action="login.htm"> <% try { //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //String url="jdbc:odbc:ODVS"; Connection conn=null;//DriverManager.getConnection(url,"downtime","downtime"); Class.forName("oracle.jdbc.driver.OracleDriver"); conn=DriverManager.getConnection("jdbc:oracle:thin:@10.10.10.2:1521:PLMDM","vvv","vvv"); String uid=request.getParameter("username"); String pwd=request.getParameter("password"); String sqlQry=("select * from USR_PASS_TB where username='"+uid+"' and password='"+pwd+"'"); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(sqlQry); if(rs.next()==true) { //response.sendRedirect("../HTML/index_group.htm"); %> <jsp:forward page="login_cae.htm" /> <% } else { //response.sendRedirect("..HTML/invalid_login.htm"); … |
| | I am using Oracle IAS 10 g for deploying my web application using a war files.. I want to access certain cgi files placed in under cgi bin besides WEB-INF on the oracle server Wht should be the entries in web.xml ?? Tried doing this but did not worked <servlet-name>CGIServlet</servlet-name> … |
| | Hi friends I need some help from VB and Oracle guru's. I am trying to create a dynamic table from VB 6.0 in Oracle (mean I want to create a table whose name is dynamic issue) For this purpose I code as follow and get error table name is not …  |
| | Hello friends, I need procedure for continous accessing oracle database using visual basic. Follwing i am giving coding use by me but some time it give disconnection error Please help for continous connectivity. [code] dim db as new ADODB.connection dim rs as new ADODB.recordset db.open "Provider=MSDAORA.1;User id=ourpro;Password=ourpro1;Persist Security info=False" [/code] …  |
| | Hi Friends, Our project is developed in J2ee technology using EJB, now we are migrating to hibernate. We are using Oracle 10g. Architecture of this project has not been satisfactory (including database) and we have several performance and maintenance issues, we are changing the architecture and database design now. I … |
| | Hi i'm trying to write a decryption code to process encrypted files. I have the error below whenever I try to initialise an cypher object of type Crypt::CBC and supplying 'Blowfish' as decryption algorithm, I get the following [QUOTE]C:\>decrypt.pl Couldn't load Crypt::Blowfish: Can't locate loadable object for module Crypt::Bl owfish … |
| | Dear Friends DataView is pouplated from an oracle database table and when i tried to Filter records which has been created in between two dates gives me misguiding rows. I have tried with different date format, still getting wrong information. [code] Dim dt as New DataSet, dv as New DataView … |
| | Hi, Can any one tell me what is oracle forms and reports? where we will run oracle forms? |
| | Hey guys I have a table, that lists people, with a correpsonding date and time for each activity. My structure is like: PersonID......Date............Time 872367.........01/01/08......15:00:00 872367.........01/01/08......16:00:00 872367.........01/01/08......18:00:00 976737.........01/01/08......19:00:00 976737.........02/01/08......16:00:00 911967.........03/01/08......18:00:00 I want to have a query that returns each persons latest activity date and time, so I want a table like: … |
| | <% try { //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //String url="jdbc:odbc:ODVS"; Connection conn=null;//DriverManager.getConnection(url,"downtime","downtime"); Class.forName("oracle.jdbc.driver.OracleDriver"); conn=DriverManager.getConnection("jdbc:oracle:SID:@10.10.10.2:1521:PLMDM","abc","abc"); String uid=request.getParameter("Username"); String pwd=request.getParameter("Password"); String sqlQry=("select * from USR_PASS_TB where Username='"+uid+"' and Password='"+pwd+"'"); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(sqlQry); if(rs.next()==true) { //response.sendRedirect("../HTML/index_group.htm"); %> <jsp:forward page="../HTML/index_group.htm" /> <% } else { //response.sendRedirect("..HTML/invalid_login.htm"); %> <jsp:forward page="../HTML/invalid_login.htm" /> <% } rs.close(); conn.close(); } catch(Exception e1) … |
| | Does anyone know how i can get a list of the java stored procedures that are inside the oracle database using oracle sql developer? If anyone has used Toad, i m referring to the list of java classes that comes up when u click the Java tab in Toad. Thanx. |
| | I need to do a lookup to a table in Oracle from a dll. Can anyone tell me what's wrong with this line: pRs->Open(ptrQuery, "DSN=MY_DSN;UID=MY_ID;PWD=MY_PWD;", adOpenForwardOnly, adOpenReadOnly, adCmdText); The code compiles without error, but when invoked by the target application, the application errors out. (It works fine when not calling …  |
| | Hey guys, say im doing a query like: select * from info where date = '21-APR-08' but i want to do it for a number of different dates, how can i create an array to hold teh dates, and then for each date in the array, execute the query? like … |
| | Hey guys I have a current query that looks something like: [CODE]select a.avalue, b.bvalue, c.cvalue from (select idVal, dummyVal as avalue from....) as a left join (select idVal, dummyVal as bvalue from....) as b on a.idVal = b.idVal left join (select idVal, dummyVal as cvalue from....) as c on b.idVal … |
| | Hi, I am wondering if anyone can help me with a small problem I am having. I am populating a gridview from an oracle DB. I only want some of these columns to be editable so I am using the code below to try and acheive this. As you can … |
| | hello well i am using dell inspiron 6000 with 2 partitions windows xp and the linux flavor kubuntu the problem is i have blue screens (different error code each time) and each time i try to restart i get "cannot find bootable device press f1...." or i get repeatedly the … |
| | can we connect from php to oracle 6. if it is possible then, how can we do it... regards shuja |
The End.