Re: Creating empty temp table from an existing view
Based on experience Oracle will actually only execute the first step
and then terminate (at least on my 9.2+ system). Try the command.
You could read the view column list from dba_tab_columns and use
dynamic SQL via execute immediate to issue the create temporary table
statement.
HTH -- Mark D Powell --
.
Relevant Pages
- Re: What is the use of "set -o monitor"?
... When I execute b.ksh, it calls a.ksh and the command "dd ... If I press control-C, then the dd commad not die. ... "Thus you cannot use the key to terminate a ...
(comp.unix.shell) - how to timeout a command
... I need to execute a command, a method of an object, which will run for an ... uncertain amount of time. ... if the command does not return, say, in two or three seconds, I would like ... to terminate it and move on. ...
(comp.lang.java) - [Full-Disclosure] Advanced usage of system() function.
... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
(Full-Disclosure) - Advanced usage of system() function.
... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit we are ... Connection closed by foreign host. ... think what we want to execute. ...
(Bugtraq) - Re: Wait for background processes to complete
... To be able to execute commands in the background and wait for their ... The documentation I am referring to is http://perldoc.perl.org/. ... You can run a command in the background with: ... There is a general problem with perl documentation: ...
(comp.lang.perl.misc) |
|
