1,488 Topics
 | |
| | I am still pretty new to writing SQL statements and I have mostly used MS Access up until now. My question is I am trying to write a single query based on the sample table below to determine how many orders were all parts orders, how many were all accessories …  |
| | can anyone tell if it is the right way to connect these tables? What is the query display customerid, b_customer_id, and h_customer_id... thxxx --customers [code=sql]drop table Customers cascade constraint; create table Customers( Customer_id Number(5) primary key not null, Credit varchar2(20), Street varchar2(20), City varchar2(12), State varchar2(2), Zip varchar2(5), Telephone varchar2(14));[/code] …  |
| | Is there any one can explain to me what is the difference between when_validate_item trigger and post_change trigger? In what kind of situation I need to use those triggers? I really feel very confused about it...It makes me stuck in my database assignment... btw, thanks for ur help... :) |
| | Hi, I am developing one website in which i have around 21 table in my database out of which 8 are master tables and rest are secondry tables. I want the data stored in some columns of master table to be displayed as drop down menu in my secondry table. … |
| | Select order_num, order_date, customer_name, description From orders,part,customer Union Select order_num, order_date, customer_name, description From orders,part,customer Where customer_name = 'Johnson's Department Store' or description = 'Gas Range'; I'm getting this error and from my understanding it looks like it should be fine: SQL command not properly ended |
| | I write programs using VB as the front end with Ms Access as the back end( database), and i will love to switch my back end to oracle ( so i think of starting from 9i).Please does anyone have the note or documentation I can read on my own in …  |
| | Hi, I am using oracle 9i. I've got hard time rying to rename columns or constraint definition. I use the following for renaming a column: [code] ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name; [/code] but I get this error [inlinecode]ORA-14155: missing PARTITION or SUBPARTITION keyword [/inlinecode]. The same thing … |
| | I have using asp.net and oracle (oracle provider) but within some time oracle sessions are full. so it gives error. have any body work on asp.net and oracle. how to handle oracle sessions. Regards. Thanks in advance... ashok salve.  |
| | I am trying to determine a way to create a timeout for a connection attempt to remote Oracle databases. If the connection isn't created in X seconds or less, regardless of the reason, I need to stop the connection attempt and report a message. Below is the relevant bit of … |
| | Hi everyone, I have a third-party application which uses DSN (in this case, only system and user DSNs) to setup database connections. I created a connection using the "Microsoft ODBC for Oracle" driver, but everytime my application needs to access the DB, I'm asked for password. I cannot change the … |
| | 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 … |
| | I'm trying to connect to Oracle Dbase using VB.net and I don't know how. I'm more familiar with Visual Foxpro 9.0 which is a lot easier. I did not find a way to connect VF to Oracle so I'll try VB.Net . 5 years ago, I am a little familiar … |
| | Hi, I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included. When creating the archive the date + … |
| | hi guys, i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad: |
| | I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when … |
| | Hello, This is my first post here, so Hi everyone :). I was advised to come to this site by a friend regarding a query that I have, so here I am. So we have the E-Commerce subject in this semester. One of the case studies given to us involves … |
| | Im a noob in vb.net 2003 and oracle...and I desperately need the expert help regarding a problem that I face.... Im working on a web based system and the system is connected to oracle. In oracle there are 4 tables and Im facing problem with one of the tables. In … |
| | I need to read simple tables from a stream. The tables are created as: CREATE TABLE ny1.allinsured1 ( pol_no numer(120, ... ) / I see the tables are streaming from source db to destination db BUT I cannot seem to access the tables from an OCI streams interface. How can … |
 | Hello DBA, Can any one help me this? The table TEST contains CNAME CNO EXTRA ------------------------------ ---------- ---------- bijaya 645896 mantri 525896 mantri12 525126 testing for null My requirement is to find the column which contains all the rows null(null column) I have created the following procedure to accomplish this … |
| | Does anyone know where to get a skeleton of perl scripts written for Oracle backup and recovery? |
| | I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige |
The End.