|
by: sbh |
last post by:
I need to copy data from a table on one Oracle server to another.
Scenario: Need to create a stored procedure in server a, database aa
that will copy data from server b, database bb, table bbb to server a,
database aa, table aaa. Let's say I have a user on server b, database
bb named userB (password pw) that has rights to table bbb.
Can anyone help me with the syntax - just for the connection part?
Is this possible with a stored...
|
by: thirdman |
last post by:
I'm trying to write a SQL that stores a result from a stored-procedure
into a temporary table.
Is there any way of doing this?
|
by: Thomasb |
last post by:
With a background in MS SQL Server programming I'm used to temporary
tables. Have just started to work with DB2 ver 7 on z/OS and stumbled
into the concept of GLOBAL TEMPORARY TABLE.
I have created a temporary database with a tables space. Verified that
DECLARE GLOBAL TEMPORARY TABLE TEMP (A INTEGER);
INSERT INTO SESSION.TEMP VALUES(10);
SELECT A FROM SESSION.TEMP;
works from a query tool.
|
by: trialproduct2004 |
last post by:
Hi all
i am new to sql server.
i want to write stored procedure in sql server to insert values into
two table whose structure is same.
i have one condition depending on which i am inserting values into
either of this table
|
by: Bilbo |
last post by:
I have a a headscratcher here:
I have a form that when submitted should do 2 things when a user enters
data and then clicks the Add button.
Here goes:
1. Call a stored procedure called AddCompany to insert the company name
from the Company Name textbox into the COMPANY table and return the
@@IDENTITY of the company name just input into the database back to a
label on the form. THIS IS WORKING.
|
|
by: satish |
last post by:
hi,
i am a learner of ms -sql server 2000, i had a doubt in stored
procedures
suppose i have a data base having 20 tables, all the tables have a
column named--DATE
can we write a store procdure to find out the data ---i mean i want
the data entered
between two days ---- if i call the stored procedure in any one of the
|
by: MooseManDan |
last post by:
I have a linked table DOWNLOAD (MS excel spreadsheet) that I copied all the information over to in MAIN DATA table, but added more fields to MAIN DATA.
How do I create the relationship to update MAIN DATA when the linked DOWNLOAD spreadsheet is updated.
Thanks in advance for all your assistance!
|
by: TruptiYadav |
last post by:
i know the child table and i have the foreign key with me .
but the DB2 script has been written by someone else and i dont know how to get the prant table name.
is there any way to know the description of the Create table command that was used to create the child table.
in fact i want to know the way through which i can get to see the Create table command that was used to creatte the child table.
|
by: ranu2006 |
last post by:
Hi All,
I want to write a stored procedure that can fetch Hierarchical data from a table
I will be passing Employee Name and I want to fetch his seniors employees and his junior employees
Tried with Connect by but didn get expected result .
Can any one help in this regard .
|
by: riyap |
last post by:
hi
can anyone help me to simplify my logic in writing code,
i have ms acess database table.i want to get the data from there(using select command with where clause) and insert into a stored procedure in oracle database.
stored procedure package has 8 i/p fields and 1 output feilds.
when i insert fields i need to get the o/p value from it and update it into ms acess DB table.
My doubt is how to get data from Acess and enter into stored...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|