1,488 Topics
 | |
| | Hi All, I am struck with following problem. Please help me out. I have defined a Oracle procedure as follows. [code] PROCEDURE JOB_EXPORT IS cur CWTYPES.cursorType; l_nextdate DATE; -- JOB_NEXT_RUN l_interval VARCHAR2(64); BEGIN OPEN cur FOR SELECT JOB_NEXT_RUN, JOB_INTERVAL FROM JOB_EXPORT_CDRS WHERE ACTIVE_STATUS=1 AND JOB_INTERVAL IS NOT NULL LOOP FETCH … |
| | Noobish query but oh well.... I am trying to implement TPC-H in Oracle. I downloaded the reference set for it which is a .rar file. The archive contains files in form of *.tbl.[number], *.tbl.u1.[number], *.tbl.u75.[number], *.tbl.u150.[number] and delete.u[1, 75, 150] How do i concatenate the files to make 1 single … |
| | HELLO, CAN I GET RESPONSES TO THE FOLLOWING QUESTIONS ON ORACLE 10g. 1. HOW CAN I CREATE 2 EXTRA CONTROL FILES FOR MY DATABASE, I CREATED ONE WHILE INSTALLING ORACLE 10g? 2. HOW DO INCREASE MY DUMP AREA SPACE? 3. I GOT THIS MESSAGE UNDER ALERTS "SQL RESPONSE TIME IS …  |
| | hello all, for few days i have been trying to connect with my oracle 9i database with visual studio 2005 using c#. i tried all the processes that i found in internet. but i fail to connect with my oracle database. i have service named GLOBAL USERNAME: first password: first … |
 | I am beginner at java.I want to learn jdbc-oracle database subjects.By downloading jdeveloper and sqldeveloper I started but I couldnt connect database.So I want to start learning jdbc-oracle from begin.I need your advices.thanks. |
| | I need some help. Some collegues need to link their AutoCAD files with an external data base, in this case in Oracle. So far pretty simple, and done... Next step is to link functionality, if a record is deleted in the db, we want the corresponding CAD drawing component deleted … |
| | hi, Please help what`s the process to insert local system pictures to web server database using ASP. |
| | hello there I am new into scripting . What is the use of unix shell scripting with oracle and how can I combine oracle with unix shell scripting? Any replies regarding this would be great. Thanks in advance, Techbrain55 |
| | Hi I'm a final year university student and i'm running into a bit of trouble with my final year project (It's very important) My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database. I really don't … |
| | hi i am doing a proj in jsp and oracle 9i. i want to read data from oracle and show it in the text boxes in html/jsp. i know how to read the data from oracle, but i cannot put it into text boxes. can anyone tell me how to … |
| | I have a JSP page with some text boxes. The user fills out the form, clicks the Apply button, the inputs get saved to an Oracle 10.g database. The form can be viewed again and the text boxes are populated with the saved data so the entries can be edited …  |
| | Hello all, When I enable Audit Trail, there are two options, AUDIT_TRAIL = DB or AUDIT_TRAIL = OS. If I use "OS", when in Windows, the audit records will be sent to the Event Viewer; but now that I am using UNIX, so can someone tell me where is the … |
| | Hi all, I am currently doing an application using MS Access 97 as front-end GUI, connecting to a back-end Oracle server. The Oracle server version is 9.x. Now I wanna use integrated security so that I won't need to enter the username/password every time I start my application. The problem … |
| | I have limited oracle experience I want to dump a copy of one db and import it into a local oracle server which I'm using for dev. My problem is that I can't sort out the connect information (user@host:port/SID) type stuff. I've tried just connecting to the remote db using …  |
| | Is there a way to query Oracle on the number of connections open (Not as the administrator). I am trying to setup connection pooling and I want something (on the client end) to check how many connections are being maintained etc. |
| | i need help in my query.. i need to compute for the difference between two time.. i already have a formula for that but the problem is, i am setting up a condition before i get the difference between two diffrenet time... i have a table named test.. it has … |
| | Hi, My name is Srinivas. im working as a software engineer in one MNC. now i want to do the oracle apps. but im in confusion to what to do in apps. 1. DBA 2. Technical Please suggest me which on is best. Regards, Srinivas Reddy. Pune. |
| | Hi, What needs to be done to connect TOAD with oracle database ?....i have installed oracle client 9i..  |
| | Hi, Im trying to modify user information on my site.for this im using java and jsp.when the user enters id,his info stored in db is to be retrieved and displayed in corresponding textboxes. I know how to access db but dont know how to put the value retrieved into textboxes …  |
 | Hi i want to select the values from my table where a column must contains some value. So i wrote this Select * from RG_TAB where CMCode = 4 and CMCode = 5 This query not giving me any result but Select * from RG_TAB where CMCode = 4 Or … |
| | |
| | hello all, can any one teach me how to connect to oracle database from asp.net in vb 2005 pls reply me with code and example if u can bye |
 | |
| | Hello Dear Experts! I need Oracle and EnterpriseDB comparison in detail. kindly help me. |
| | Hi everyone!! please help me....working new in oracle forms 10g..... its web application (using forms 10g front end, oracle 10g back end)....I try to call crystal report in my forms....how can i call the report...please give some ideas.....but i did Database connection......where should i specify URL in my forms....anybody know … |
| | hi, i need urgent help as i am facing problems in copying database oracle from one hard drive to another hard drive,please give me step by step instructions on how to do it,also please suggest a software which can transfer the database and the settings, thanks in advance |
| | How to insert the Oracle 9i FIELD NAME into VB6.0 COMBO BOX eg : desc customer; This table have 3 fields : CustomerId, CustomerName & CustomerAddress CombCust --> The above field names should be displayed while drop down of combo box Thank you in advance |
| | hi, can you please give a step by step procedure on how to connect oracle database with jsp. I am new to the language and cant quite figure a way out.My first page is a user login and therafter username is used.How do i use sessions for this? Thanks in … |
| | friends i got problem in connection between oracle and jsp as given in cracking codes in j2me in following codes <?xml version="1.0"?> <jsp:root xmlns:jsp="http://java.sun.com/products/jsp/dtd/jsp_1_0.dtd"> <main> <title>Branch Info</title> <%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%> <%java.sql.connection db=java.sql.DriverManager.getConnecton("jdbc:odbc:master","sa","amrit");%> <%java.sql.Statement st=db.createStatement();%> <%java.sql.ResultSet rs;%> <%rs=st.executeQuery("select item_code,quantity,unit_price form stock_mast;");%> <%while(rs.next(()){%> <%String name=rs.getString("item_code");%> <%int aId=rs.getInt("quantity");%> <%int uPrice=rs.getInt("unit_price");%> <item_code><%=name%><quantity><%=aId%></quantity><unit_price><%=uPrice%></unit_price></item_code> <%} %> <%rs.close();%> </main> … |
| | I am new to .Net and this forum. I am using Visual Studio 2005 and Oracle as a DB. I am creating a Web page Using Gridview from the Query [COLOR="Red"][/COLOR] Select Name,Sex,Country from Emp [COLOR="red"][B]Now I want to create a Stored Procedure from the above query in Oracle.[/B][/COLOR]How will … |
The End.