Shutdown Immediate will not complete if there are any users logged in the the database with the DBA role.
Someone once told me that and I believed them. Testing has shown this to be a false s...
http://www.experts-exchange.com/Database/Oracle/Q_20296833.html
Zones:
OracleDate Answered: 05/06/2002 Grade: B Views: 12
How do you code a simple immediate redirect from one page to another>
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/HTML/Q_20792227.ht...
Zones:
HTMLDate Answered: 11/09/2003 Grade: A Views: 0
I still haven't worked out how to do this. Anyone know?
Thanks.
http://www.experts-exchange.com/Programming/Misc/Q_20815843.html
Zones:
ProgrammingDate Answered: 12/09/2003 Grade: A Views: 0
Hi,
Requirement :
Use bind variables to better performance of a query.
The query would return multiple rows with multiple
columns.
Approach :
Use PL/SQL's EXECUTE IMMEDIATE dyna...
http://www.experts-exchange.com/Database/Oracle/Q_20258383.html
Zones:
OracleDate Answered: 04/27/2002 Grade: A Views: 0
Dual boot Win 98SE/Win 2K Pro system. Tried to install 80 GB disk but Award v 4.51 Bios won't permit > 33.8 GB. Seagate DDO program used. Removed 80 GB disk but now when I logon I get message that...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/2000/Q_20280926.htm...
Zones:
Windows 2000Date Answered: 07/24/2003 Grade: A Views: 0
Sheesh, this new Debug class and its Listeners confusion...how the heck do I just write output to my good old Immediate window...or the just-as-handy equivalent of an Immediate window?
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20325600.html
Zones:
.NETDate Answered: 07/19/2002 Grade: A Views: 0
Im having problems with the following statement in 8.0.5
v_seq := 'SEQ_TAPNBR_'||(v_yr);
v_seq := v_seq ||'.NEXTVAL';
EXECUTE IMMEDIATE 'select '||v_seq||' from dual' into v_num;
this works...
http://www.experts-exchange.com/Database/Oracle/Q_20327841.html
Zones:
OracleDate Answered: 09/27/2003 Grade: A Views: 0
I basically want to be able re-direct the output of the VB immediate window to a file (probably with a add-in).
Does anyone know how to read the contents of the immediate window +/- how to detec...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20413033.html
Zones:
Visual BasicDate Answered: 12/22/2002 Grade: A Views: 0
In my trigger I want to run:
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@test(the_query); ("the_query" is a variable)
I get the error PLS-00221: 'EXECUTE_IMMEDIATE' is not a procedure or is undefine...
http://www.experts-exchange.com/Database/Oracle/Q_20652169.html
Zones:
OracleDate Answered: 06/18/2003 Grade: A Views: 0
Hi,
I have the following script in a proc. I am not able to exec the sting using execute immediate..
>>>>>>>>>>
for v_count 1..8
loop
V_COMMAND := ' WSP_INS_UPD_FORM2(V'||V_COUN...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20700735.html
Zones:
DatabasesDate Answered: 08/25/2003 Grade: C Views: 4
