by: michi |
last post by:
Hello there...
Can anybody tell me what is the difference when I excecute a sql
statement within pl sql with/without "execute immediate" statement
Thanks
Michi :)
|
by: finlma |
last post by:
I'm trying to run an EXECUTE IMMEDIATE within a PL/SQL if loop but it
doesn't work for me. I'm trying to create a column conditionally but
it doesn't work. It fails because there are apostrophes...
|
by: Gregor =?UTF-8?B?S292YcSN?= |
last post by:
Hi!
I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO...
|
by: kiss07 |
last post by:
Hi,
i want 2 and 3 rd max salary in a table .i want a single query.
please help..
Arun
|
by: Armin Zingler |
last post by:
Hi,
I feel fooled.. In the immediate window, if I enter
? DateTime.Now.Kind
I get "Unspecified {0}". The result - I expected "local" - lead to some time
consuming deliberations. Today, I...
|
by: lakon15 |
last post by:
Dear all,
I'll try to convert from SQL server Store Procedure to DB2 Store Procedure.
I've make SP under DB2 like this
CREATE PROCEDURE GetSearchedRecords (pKeyWords VARCHAR(1000),
...
|
by: kannan1983 |
last post by:
what is the difference between
TRUNCATE TABLE table_name
and
EXECUTE IMMEDIATE'TRUNCATE TABLE table_name'
is there any performance issue between this two?
which is best to use in...
|
by: DoctorIce |
last post by:
Guys,
Im experiencing a strange problem.
I'm using the Immediate window in Access 2000 to track output from a program as it loops through a recordset.
So, I'm using Debug.Print statements to sent...
|
by: umesh049 |
last post by:
Hello,
I want to delete all the date of all the table in a scheman.
but i got error at execute immediate statement.
can any body help me.
thanks
|
by: Rahul Babbar |
last post by:
Hi,
I have the following doubt.
Suppose I use the execute immediate statement and the statement to be
executed is a Select statement from the sysibm.sysdummy1 table which
will always return...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|