Oracle Help
in [SQL]
|
How to update a table with another table Hi to All, I have in my 'schema' 2 tables: CREATE TABLE T_ITEMS ( ITEM_GROUP VARCHAR2(10 BYTE) NOT NULL, ITEM_CODE VARCHAR2(25 BYTE) NOT NULL, ITEM_DESCRIPTION VARCHAR2(40 BYTE) NOT NULL, ITEM_QTA NUMBER(16,4), ITEM_PRICE NUMBER(18,5) ) TABLESPACE DOM8DATI PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 ... 23 Jan 2008 09:31
migration to Oracle spatial Dear Suresh, Have you got any solution for the migration St_ to SDO_. Pls let me know abt it. Thanks, Guru -- Message posted using http://www.talkaboutdatabases.com/group/comp.databases.oracle.misc/ More information at http://www.talkaboutdatabases.com/faq.html ... 23 Jan 2008 03:19
Help on Update query I need to move 490 records from a column named TRACKID to PS_NAME. After I do that I need to also set STATUS_CD to "RETIRED" and insert NULL values where the TRACKID used to be. I have succesfully found the 490 records with the following select statement: SELECT MASTER_INVENTORY."TRACKID", MASTER_INVENTORY... 23 Jan 2008 10:38
Best location for new graduates? I'm just finishing up my B.A. in database technologies, and I've been looking for my first position in the field. There are lots of Oracle jobs in my area (Tampa, FL) but no one seems to be interested in new graduates with no experience. I've heard that other areas in the US aren't as competitive and often hire... 28 Jan 2008 14:47
Req: Oracle DBA required for Herndon, VA = = = > Please forward profiles to michael.vigie(a)pyramidconsultinginc.com Hi, Please let me know if you have any suitable candidate references for the following requirement: Senior Oracle DBA 3+ Months Herndon, VA ¡V Local Candidates required who can come in for a face to face interview by themsel... 22 Jan 2008 09:34
Oracle settings for letter template error Options Hi, We have an Oracle 6i forms set up which displays MS Word letters this in-house information system of ours. Everytime we Protect Form on a Word letter (to activate the Form functionality) and then try to display it via Oracle we get these two error messages 'Run-Time error 509 - the InsertFieldChars command is ... 21 Jan 2008 21:49
Table analysis What I am trying to accomplish is to get an understanding of how much columns are being used in a table. We are working on creating a data warehouse, and I need to know which columns are important and being used and vice versa. My plan is to get a number of how many nulls / not nulls there are for each record in ... 21 Jan 2008 12:52
alter index (Oracle Text index) rebuild on different schema => no rights Krabatz wrote: Hi, Core question: I'd like to execute this statement as "appuser": ALTER INDEX adminuser.my_oracle_text_index REBUILD; Why?!? Why not rebuild the index *as owner*?!? Error message: ORA-01418: specified index does not exist How is the syntax to give app_user the ... 24 Jan 2008 15:07
alter index (Oracle Text index) rebuild on different schema => no rights Hi, Core question: I'd like to execute this statement as "appuser": ALTER INDEX adminuser.my_oracle_text_index REBUILD; Error message: ORA-01418: specified index does not exist How is the syntax to give app_user the grants for alter index of schema_owner_user.my_oracle_text_index? More specialized q... 23 Jan 2008 14:00 |