I need to export a number of rows (from different tables- ie, all the related information about an entity - for eg: a Customer) to another DB in Oracle. How d开发者_运维问答o we do this? I am using a
I have a table containing language translations. It has 30 columns for 30 languages. My requirement is to search from all columns for a particular word (say \"hello\").
I have two tables table A and table B . Table A contain column colA which contains values (1,3,5,7) Table B contain column colB which contains values (2,4,6,8)
I wo开发者_开发技巧uld like to find the number of rows in a cursor. Is there a keyword that can help? Using COUNT, we have to write a query. Any help will be greatly appreciated.The cursor_variable.%R
Quick and straightforward question: I am writing a PL/SQL stored procedure. It contains some execute immediate calls that might fail. I don\'t want to raise an error. I would like the stored procedur
Does dbms_output.put_line decrease the performance in plsql c开发者_如何学Goode?Every extra line of code decreases the performance of code. After all, it is an extra instruction to be executed, which
I am using Oracle 11g, and I have a lot of stored procedure code that use the same SELECT statement (but a complex one), just a different input in a where clause:
I received a function from a co worker as a solution for a problem I\'m facing with one of our applications that included reference to the Oracle Library UTL_TCP (write_text). However, the solution is
Is there anything like thread in Oracle forms for updating one part? I want to create a message box and update that part with the new events, so I need开发者_StackOverflow社区 to have something like t
Ok imagine this situation. I make a change to a pl/sql module, recompile it and everything is fine. No errors.
加载中,请稍侯......