2,627 Topics
 | |
| | below is my oracle procedure [code] DECLARE TYPE r_cursor IS REF CURSOR; c_emp r_cursor; er PLAN_T%ROWTYPE; BEGIN OPEN c_emp FOR SELECT * FROM PLAN_T WHERE ROWNUM < 5; LOOP FETCH c_emp INTO er; EXIT WHEN c_emp%NOTFOUND; dbms_output.put_line(er.OBJ_ID || ' - ' || er.NAME); END LOOP; CLOSE c_emp; END; [/code] it … |
| | Hi everyone! My name is Mulusa and I am an Oracle DBA & Developer; and a Microsoft Systems Engineer. I look forward to fit in as a resourceful member of this community.  |
| | what can possibly be done to insert a time stamp and a date into oracle database using Java code |
| | Hi All, Assist me on how to insert and retrieve images to an oracle database with ordimage data type. Any help will be highly appreciated. |
| | Hi to ALL I tried to upload file using JSP and Oracle. The first page is page.jsp which the user choose the file /////////////// [code=jsp]<%@ page language="java" %> <%@ page session="true" %> <HTml> <HEAD><TITLE>Display file upload form to the user</TITLE></HEAD> <BODY> <%=session.getAttribute("Name")%> <FORM ENCTYPE="multipart/form-data" ACTION= "upload_page.jsp" METHOD=POST> <br><br><br> <center> <table …  |
| | I have DB Oracle table User include : ID,USERID,MONEY,TIME . I was select a record (The time : 4/11/2009 5:52:55 PM ) [icode]select time from user where user ='John' and money>300 [/icode]. Now i have value : time = rscon("time") Now i want calculate number day from now to the …  |
| | My Dell Powervault 220S disk array contains an Oracle database that is currently down. The errors within the database point to an I/O error with the Raw disks. The Windows Event Viewer has the following error at the time the database went down: "The device \Device\Scsi\mraid35x1 did not respond within … |
| | i m just at this community. something about myself: i m an engineering student. i know basics of c, c++, vb, oracle but have been away from programming since quite some time. i want to learn hacking. i just want to be a computer nerd but not been able to … |
| | In Oracle its showing ClusterId for every table and View.Can anyone tell how to set ClusterID's.Thanks in Advance. |
| | I need to know how to access two tables which has some reference values within the table.I need the Java Code to Fetch Both the tables values which are same and have to display it |
| | Hi friends I have written my first code using dynamic SQL which is as follows [code=sql]CREATE OR REPLACE PROCEDURE Insrt_Chld_Dtl AS CURSOR_ID INTEGER; V_FORMAT_ID NUMBER(20):=1; COL_NM VARCHAR2(50); VLS VARCHAR2(50); V_COL_NO VARCHAR2(20); SEARCH_STRING VARCHAR2(20); --ID VARCHAR2(100); PRNT_VL VARCHAR2(100); COL_CNT INTEGER; V_SQL VARCHAR2(200); CURSOR FETCH_MST_DTLS(V_FORMAT_ID VARCHAR2,V_COL VARCHAR2) IS SELECT WHETHER_COMBO, ABV, DESCRIPTION, … |
| | Hi everybody, This is Shyamala from Chennai. I'm a mom and a software professional. I've been doing development work - mostly part time for 7 years. I've worked in C, Unix, Oracle and more recently in ASP.Net 1.1, C# and SQL Server. I'm looking for work-from-home opportunities as my kids …  |
| | hiii, i hav made a servlet and connect it to database through oracle. But while running it i m encountering this error "Couldn't load database driver: oracle.jdbc.driver.OracleDriver". Please help me as i unable to proceed further in my project. my servlet is like this:: [code] /* * facregistrationform.java * * … |
| | I am old to this site 9/2008 but new to it because I did not take full advantage of the site back then. I remembered I had been a member years back when I was googling something and your site came up as a reference. I remember attending a TODCON … |
| | Hello, i have to export a column in vb.net to Oracle database. only one table. How to start? |
| | I need a complete source code of ONLINE EXAMINATION SYSTEM in JSP+ORACLE. Can sombody help me? my e-mail id : <EMAIL SNIPPED> |
| | Hi alls, I'm using console application to pull data between 2 different database and column name (from Oracle to Sql 2008). The connection already done..but i'm having problem to select and insert from oracle to sql... The details as below :- Oracle DB Table :- Event Column : ID , … |
| | Hello, I am trying to run my tables in the Sql Workshop using the Sql Commands option in Oracle, and I get this error - "ORA-00922: missing or invalid option". I read that this is somehow related to the NOT NULL option, but I think this is how my table … |
| | hi, this is saif from pakistan. i have get a project to make a database on library management system.could u tell me that how many entities i can add in this data base.if u know pls reply me wid the names and how. thank u. |
| | I am trying to call the Oracle stored procedure in java. I have given below,stored procedure and java method which calls the stored procedure and returns the result set. I am getting the error Invalid column type :1111 or invalid column index. Can anyone tell me whats wrong in the … |
| | Im trying to run a query like this: Display the names of pairs of customers who have booked the same room together with the details of the location and room. I did try like this: [CODE]select cust_name, room_name, cost_per_day, capacity, loc_name, avenue_site.address from customer, aroom, booking, avenue_site WHERE aroom.room# = … |
| | I am a 3rd year student.this is my minor project.i have to make a project using vb as front end & oracle as back end.In this i have to design a form in vb which contains company information.The companies which are coming in campus for selecting students have some criteria.these …  |
| | I am using VB6 and Oracle in my project.When I open an .exe one session gets created. If the application is doing some insert or Update to my Datatbase then, I want a Session to be created and after completing that transaction(DML Statement) ,I want that sesssion to be destroyed … |
| | plz someone help me how do i add the current date programmaticaly to the database.my databse is oracle 10g and front end is in vb6.0.plz plz help me.its very urgent |
| | PARTITION ROTATION PROBLEM CASE - Once a day application pupulates table which is used during the day. Next day the data are purged and replaced with the fresh set of rows. The table is relitevly big - about 1GB of data. Application does truncate the table and repopulates it anew. … |
| | Hi, I've been having this problem in which when i click on any google search link, it redirects me to some other page. I am experiencing this both in firefox and in IE. I've serached and found out that people have overcome this by using hijackthis. I've downnloaded hijack this …  |
| | Can any body mail me the codes with snapshots for connectivity between oracle and CMP(EJB 3.0) . Can anybody suggest me the book for Java Enterprise Edition 5 with examples using Netbeans 6.1 or later. Mail me at <EMAIL SNIPPED> |
| | I have to navigate between the records from the dept table. But when I am tryng to do that I get stuck at teh second record. and teh inc value gets reset to 0. Please let me know an alternative to this. I guess maintaining session state is an option …  |
| | Hi Alls, I'm try to send value from textbox in vb.net to other textbox in oracleform....how to do yaaa?....or the best way i using cursor location to put in the data?...can anyone help me plzz.. |
| | I've tried to make connection with oracle database using code: import java.io.*; import java.sql.*; public class dbcon{ public static void main(String[] args) { try{ String driver="oracle.jdbc.driver.OracleDriver"; Class.forName(driver); String jdbcURL="jdbc:oracle:thin:@127.0.0.1:1521:stud"; String username="scott"; String password="tiger"; Connection conn=DriverManager.getConnection(jdbcURL,username,password); System.out.println("***Connected to the database***"); conn.close(); }catch(ClassNotFoundException e){ System.out.println("could not find the database driver"); }catch(SQLException e){ …  |
 | Good Morning all, I need some help with loading a file into a sybase IQ table with the "LOAD INTO" statement. I have never used it before and I cant seem to get myhead around how I am supposed to implement it in my java app. I have a stateless … |
| | I'm looking forwards to attend such course: [url=http://unex.uci.edu/certificates/it/oracle_db/courses.asp]http://unex.uci.edu/certificates/it/oracle_db/courses.asp[/url].. look at the dates and time. Its quite intensive, my question: will i have a chance to write notes, because obviously i can remember all what i'm going to learn in one class, there must be my reference to review. Otherwise, it … |
| | I want to develop a web app that can allow the user to change the type of database he/she is using(Access, Sql Server, Oracle), just by changing the connection properties in a properties file. I am assuming that this is possible. Would it become too complicated meaning way too much …  |
| | I have to make a database in oracle and connect it with Java. But I'm not able to do so. Please help. |
| | Hi, I want to write c++ programme that it search oracle Jinitiator in my computer if find no then it autimatically install the Jinitiator in my computer. How i do this please help me?? |
| | hi everyone i want to delete arecords from my databse which is in oracle through form which is in vb.when i enter the primary of a partcular table and click detele.it is shown in the massagebox that "a record has been deleteed"but when i ckeck in database the record remains … |
| | I am trying to use this syntax to no avail: [code=sql]SELECT C_Name, ORDERS.O_ID, SUM(ITEM_ORDERED.QUANTITY*PRODUCT.P_PRICE) AS TOTAL_PRICE FROM CUSTOMER, ORDERS, ITEM_ORDERED, PRODUCT WHERE CUSTOMER.C_ID=ORDERS.C_ID AND ORDERS.O_ID=ITEM_ORDERED.O_ID AND ITEM_ORDERED.P_ID=PRODUCT.P_ID GROUP BY ORDERS.O_ID;[/code] My 4 tables would look like this: [U]customer[/U] [U]order[/U] [U]item_ordered[/U] [U]Product[/U] PK C_ID PK O_ID PK,FK O_ID PK P_ID C_Name … |
| | Hi, I have an oracle sql query that return many rows. The result will be shown in an html table in column format. I have html table that with the static header. I need to generate dynamic rows depending upon the result of the queries. Thanks, Reuben |
| | Please how can I write a query to select list of building its building code and number of rooms in each building. |
| | SQL QUERY [code]if ($_SERVER ['REQUEST_METHOD'] == 'POST') { if ($_POST['mylist1'] == 'm2') { $sql="SELECT Products, TABLE 1"; $rs=odbc_exec($conn,$sql); odbc_result_all($rs); echo 'With this package you can registar for any of our domains'; } elseif ($_POST['mylist'] == 'm3') { $sql="SELECT Products, Table2"; $rs=odbc_exec($conn,$sql); odbc_result_all($rs); echo 'With this package you can registar for … |
| | [i] Topic The topic of this question is: Creating a MySQL table and Entity from Database. [/i] [icode] Hello and Thank you in advance for any assistance. [/icode] [u] [b] Purpose: [/b] [/u] [b] This is another attempt to render data in a visual web javaserver faces table. The purpose … |
| | any one help me to connect my vb6 form value to oracle 9i database ? How to retrieve a data from a table in oracle to visual basic form and to search on vb frm form retrieve the search value from oracle please help? also help me to how to … |
| | Hi Guys, My name is Allen Raymond, you can call me Ray. I'm a new member to this site and a old member to the IT field. You guys need any help with [B][COLOR="Red"]Oracle [/COLOR]Forms Migration[/B] and such, feel free to contact me@ : [email]raymondallen.raymond@gmail.com[/email] Also please visit my website … |
| | [i] Topic The topic of this question is: tracking the content of an array in a session bean debug sessionbean1.java [/i] [icode] Hello and Thank you in advance for any assistance. [/icode] [u] [b] Purpose: [/b] [/u] [b] The purpose of this code is to try to find the best … |
| | Hi,Friends Im facing problem in paging using jsp & oracle ,in this code only 1 to 10 values displying,when im clicking on next its displying nothing.Means not taking next values. [code=JSP]<%@ page language="java" import="java.sql.*;"%> <html> <head> </head> <body> <br><br><br> <% int offset=0; int ofset = 0; if(request.getParameter("offset")!=null) { offset= Integer.parseInt(request.getParameter("offset").toString()); … |
| | i have a Problem to know how much time the server take to execute an SQL command . I user Oracle Db and SQL DB thanx |
| | [i] Name: The name of this question is: carbon_copy [/i] [icode] Hello and Thank you in advance for any assistance. [/icode] [u] [b] Purpose: [/b] [/u] [b] The purpose of this code is create a desktop app and web app. The web app has the destop apps library. Create a … |
| | Hi I entered http:\\mandar\isqlplus on the address bar but I,m getting Invalid syntax error. mandar is my computer name. Pls help me out Is there any way to solve this error |
| | Heya, Not sure this is the best place to post but can't see a better forum :P Not 100% sure I've done this right so looking for some clarification. Thankies Steph -------------------------------------------------------------------------------- CreateTables.SQL [code] DROP TABLE student; DROP SEQUENCE student_counter; CREATE SEQUENCE student_counter INCREMENT BY 1 START WITH 1 NOMAXVALUE … |
| | Hi I'd like to know if is possible update a record when load a table. The update must be over a record with a primary key. For example: I have a record with: id|date_begin|date_end|data 2|02/03/2009|NULL|0 and I want that line to be update when a record like 2|02/03/2009|10/03/2009|56,7 comes. Is … |
The End.