1,135 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 … | |
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 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 … | |
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 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 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'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 … | |
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 … | |
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 | |
Hello DBAs, Do you have any idea about the XML file used in SP. I want to pass it as input parameter. Thanks, BMantri | |
I've created a sql statement that I'm try get the number of messages that will expire during a certain time period. I'm looking to purge messages according to mm/dd/yyyy. I'm having a world of difficulty figuring the statement format out assistence would be appriciate. SQL script: select originationtime, expirationtime, ((TO_DATE('01/01/1970', … | |
OK, I'm fairly new to PL/SQL, adn I have a query to write, which is confusing me. Let me explain: I have a table, with three fields, CustID, CustName, Number What I want to do, is identify and display all rows in the table, where the last four digits of … | |
create a view as superuser create view V_CUSTOMERS based on Customers Table and give an access to enter, select records to Appuse01,Appuser02,Appuser) and Appuser04 for all the columns excepting Price and Total_val. These two columns will be update by procedure. They should be able to see their records only and … | |
Greetings, I'm having a heck of a time trying to get this pl/sql program to work. I'm to invoke it using shopper id and then again by shopper last name. I've banged my head on this for a while now and it seems that every change I make creates more … | |
Hi, I want to store the text data with apostrophe in the table. I tried through this query like this insert into temp values(101,'vijaya's'); but it is giving error - missing comma Could anybody help this sql query for the following requirement? NAME vijaya's rajani's | |
Hi All I am trying to connect to my database from the front end in VB.NET 2003, the connection strings that i have tried are not working at present. I have VB.NET 2003 program from last year but that was using access as the back end and VB.NET 2003 as … |
The End.