1,488 Topics
 | |
| | Please can somebody tell me the difference between web development and web programming.  |
 | 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 …  |
| | 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 …  |
 | |
| | 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 … |
| | Is oracle 9i server , still good enough for todays applications, are there any new features that are worth considering in the latest versions??? |
| | 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, 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. |
| | 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 … |
| | can we connect from php to oracle 6. if it is possible then, how can we do it... regards shuja |
| | hello frnz...How to code for a login form by taking data from Oracle db? M having a table Employee having attribute as emplogin and emppwd...from there i want to check that whether the user has entered the correct data or not... I mean i want to match the entered data … |
| | I have a JSP that works with an Oracle 9i database. On my local windows workstation (using Tomcat) where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server (Tomcat) connecting to the same Schema processes very … |
| | I have an Oracle 10g application, built using Oracle PL/SQL Toolkits and PSPs, using an Oracle database with an HTML front-end (hosted by an Apache web server). When using the WPG_DOCLOAD package to add attachments to the database, the mime type for ".msg" files end up being application/octet-stream rather than … |
| | Hi all! I really hope someone can do a huge favor and help my group out! We are students and we are trying to complete an assignment to create an interface page using jsp and oracle. Using XP pro we have installed all of the above. We then configured apache … |
| | How to write a procedure which takes integer N as its IN parameter and print a number series (up to N) in the Following format. 1 2 2 3 3 3 4 4 4 4 : - - - N N N N N…………N |
| | can any one Suggest me a good E-BOOK for SQL server 2005?? |
| | this is the oracle GUI [code] import javax.swing.*; import java.awt.*; import java.awt.event.*; public class OracleGUI extends JFrame implements ActionListener { // Define constants public static final String GET_QUESTION = "I will answer any question. Let me know yours.\n" + "Type your question in the following and hit Submit."; public static … |
The End.