Oracle Help
in [SQL]
|
copy table data to another database programatically anyone have code snippets to copy table contents from one database to another? i usually use toad and make 2 database connections, then copy data across, but i really would like to find more automated way. ... 11 Jan 2008 04:22
adding a comment to user accounts When creating a user account, is there a good way to add a comment regarding that user account? Something like "test account for ldap synchronizer", etc? Many TIA! Mark -- Mark Harrison Pixar Animation Studios ... 9 Jan 2008 16:52
External Table Question I love these external tables. It really gets rid of the old UTL_FILE.GET_LINE. Anyhow, is there a way to create an external table where the filename is dynamic? Basically the filename changes a couple of times during the process....... Not sure if this can be done short of re-creating the table, but I tho... 14 Jan 2008 13:53
Experiences with database extensibility The existing server extensibilities in modern DBMSs have been critical in our company's development of software products that improve database performance for certain scientific computing applications. We are planning to develop other products that will utilize an extensible database engine, and so we would be grat... 9 Jan 2008 09:22
copy table to another schema programatically anyone have code snippets that copy a table from one schema to another? i usually use toad to do this but i really would like to find more automated way. ... 21 Jan 2008 14:00
Fuzzy string search? Hello, in our application it would be very helpful, if the search wouldn't return only exact matches, but also similar items, e.g. search for "models" returns also "model" search for "exmaple" returns also "example" search for "dl365" returns also "dl385" How can I do this with Oracle? Is there any extensi... 10 Jan 2008 15:14
creating tables info. please hi all, i have some big tables i am generating in excel, and i want to create them in my DB, since they are many and every one is >20 000 rows, i want to ask if there is any way to expand the amounts of rows oracle takes in every copy - paste. because as my settings are now, when copying and pasting, oracle has a ... 8 Jan 2008 08:11
read from registry - vb 6.0 Hello, How can I read from registry (VB 6.0) ? Need sample code, please. Thanks :) ... 10 Jan 2008 06:29
DBMS_OUTPUT.PUT_LINE problem. Hi, I am trying to execute my newly created 'Login' stored procedure. For some reasons I get error on dbms_outout.put_line line code. Can someone look into the block below and tell me what the problem is...? Below is the version, code and error msg. Any help is greatly appreciated. ---beginin of the code --... 11 Jan 2008 22:15
Cursors Hi All, I've looked over some internet pages and have not found the solution yet..... I have a cursor which is the same in terms of columns for 5 tables, except the table name is different. Can I create some type of REF cursor or something where I can change the table name so I can use the same select? ... 7 Jan 2008 17:22 |