Oracle Database Forum

Hello I have to two tables as following ----------------------------- create table orders (orderid number primary key, orderdate date,Ename varcarh2(20), ItemID number,ItemName varchar2(20), Itemtype varchar2(20),tons number); sql>table created

Hello How to Call.Swf file into oracle form6i? Looking forword. Tanks in advance.

Hi, I am a freelance Oracle content writer, with OCP 11g and OTN expert level to my credit. I am regular oracle blog writer on web and received good reviews. If you wish to have oracle article or content writing services, kindly contact me for the same.

Let us have a look at the examples for each of the above mentioned SQL functions and WHERE clause operator REGEXP_LIKE Syntax: REGEXP_LIKE(source_string, pattern ) source_string - can be column of CHAR, VARCHAR2, CLOB, NCHAR, NVARCHAR2, and NCLOB but not LONG datatypes

Hello I want to Drop a primary key Referenced to other foriegn key. I try the following method --------------------- alter table Stock drop constraint SYS_C005460; --------------------- But it give me The following Message. ORA-02273: this unique/primary key is referenced by some foreign keys.

i am getting the following error while updating a clob field. ERROR java.sql.SQLException: Data size bigger than max size forthis type: 4003 19:28:27,499 ERROR at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) 19:28:27,499 ERROR at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) 19:28:27,499 ERROR at...

CREATE TABLE CP_INTFDC (ID_ACQ_IIC number(11,0) not null, ID_FWD_IIC number(11,0) not null, ID_INCOMING_TIMER number(6,0) DEFAULT 600 NOT NULL, ID_OUTGOING_TIMER number(6,0) DEFAULT 30 NOT NULL, ID_STDIN_IND varchar2(1) DEFAULT 2 NOT NULL, ); I am having a problem invalid indentifier when i...

hi, i've one question. I'm supposed to create oracle user on click of a button using oracle forms. I'm calling a procedure which i've written in sql+ which is supposed to create the user. The problem is that i'm able to create user by writing execute immediate statement in the procedure, but i'm not able to grant connect to the user. Hence...

Hi, I'm geting the following error message in alert log of my RAC DEV db,please help me on this Sat Nov 17 28 17:11:51 2007 Errors in file /oracle/export/ORACLE/lmon_26410_tick2.trc: ORA-29740: evicted by member %d, group incarnation %d Fri Nov 17 28 17:11:51 2007 Trace dumping is performing id= Fri Nov 17 28 17:11:51 2007

Hi, sorry for what I'm sure is a really stupid question but I've just recently started using Oracle. Basically, I have a table called products containing the details of various products (mobile phones etc.) and each product is to have a rating between 1 and 5. I have a column called product_rating of type number(1,0) but don't know how to...

I have developed a report in developer 6i. It properly prints on laser printer but it do not print on receipt printer (CZERLOP). Printing job has sent to printer & printer also detect this job but no text print on paper . when i send print from other application like ms.word,excel and pdf , printer print all text of page. I also convert report...

Ok, let me see if I can explain this clearly. What I'm trying to do is generate a query that looks for duplicate start times. The caveat here is there are certain character strings that have to be present for it to be considered a duplicate. Here is the existing query I have: SELECT AL2.PS, AL2.ASSETS, AL2.PT, AL2.NP, AL2.NN, AL2.AS, AL2.PR,...

These are my emp table records EmpId EmpName 1 AAA 2 CCC 3 BBB I want to generate xml in below format. <emp> <1>AAA</1> <2>CCC</2>

I received a SQL-2113 error on an Oracle 10g database and I'm not sure what that error means.

Hello Sir I have Error with the following tables one is And one is. Income table Columns. Date ItemID ItemType Amount DriverName TruckNo --------------------- Stock Table columns. Itemid ItemName ItemType Amount -----------------------------------

Hello I have problem with the following table For example i have two tables Stock,Income stock table columns Date,itemid,itemName,ItemType,Tons. Income table columns. Date,ITemid,itemtype,tons.

Hi, I am doing a paging task. In order to do that I want to get data 10 by 10 raws from a table. How can I do this using "rownum" ? I tried in this way SELECT FROM ( SELECT UPLOAD_DATE_TIME,TYPE_OF_UPLOAD,PERFORMED_BY,STATUS,CLFILE_COUNT,STCMAS_COUNT,CLSTMAS_COUNT,OPENTRN_COUNT,START_TIME,FINISH_TIME,rownum rn FROM ONLINE_ACTION_HISTORY...

How can i run oracle report 6i from client? In server machine its worked (screen preview) but in client machine it shows log in window. When i give user name, password and host name its not response.

Hi, In our company we use RMAN to backup our oracle db in Unix platform. we have never test the restore and we want to test it in another environment. do you sugest any document for helping us restore the oracle db using rman from unix platform on windows? any sugestion will be very helpful

CREATE OR REPLACE PROCEDURE thqvb_TEST(g_plazano VARCHAR2,g_oprdate VARCHAR2) IS BEGIN DECLARE thq_oprdate date; thq_plazano varchar2(3); thq_reconcilecode varchar2(3); thq_badgeno number(5); thq_bagno number(4); thq_jobno number(2);

I have a table , values are available in name column, i want to display senthil at first and remaining name in order andone can help me on this?

Hi, I have following problem. I have to run a query where one of the result fields should be within range of values I got from different table. Query 1 select column_x from table1 where filed_x = 'Y' this query gives me 33 different alphanumeric values

Hi, I have given a "select *" statement for a view. It gives all the values for the "where" condition mentioned. But when I give "select column_name " for the same "where" condition, I am getting an error. e.g. if I give "select * from SERVC_MGR_REPT_V_CELL where EMPLOYEES_NAME='Ma, Stephen';", I am getting all the values. But if I give...

Dear all, My Query is below, Update iz_zone, iz_page, iz_object_zone, iz_page_inv SET iz_zone.to_spg = 1,iz_zone.from_spg = 1,iz_page.spg_no=1,iz_object_zone.to_spg = 1,iz_object_zone.from_spg = 1,iz_page_inv.src_pg_no = 1 where iz_page.page_inv_id = iz_page_inv.page_inv_id and iz_zone.page_id = iz_object_zone.page_id and iz_zone.page_id =...

i want to transfer my tables stored in my oracle 10g to my friend's oracle 10g installed on his laptop.is this possible??if yes, then please guide me to do this.