473,698 Members | 2,346 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Amend and udate data using 10G EM ?

GPD
I thought I had done this before but cant see a way how.

Am sure I once opened a table and amended some data.

Anyone know if possible or how, any permissions needed from 10G EM.

PS

I know I can view the data. I want to amend a few values thats all.
Normally use toad but am on a 64 bit server. Hence no free toad.
Mar 31 '08 #1
1 1819
GPD
No Bank of America is not one of them, Use to be a long long time ago.

And to be fair the only data they are trying to change is Evironmental
paramrters for server names etc No acount information can be accessed at
this level.

eg when moving from a live to test server, or Dr server. or parallel server
thats being upgraded.

IT is not retail and is mainly a bank to bank , corporate system.

"joel garry" <jo********@hom e.comwrote in message
news:58******** *************** ***********@i12 g2000prf.google groups.com...
On Apr 3, 7:25 am, "Shakespear e" <what...@xs4all .nlwrote:
"GPD" <j...@thedawes. gotadsl.co.uk.n ospamschreef in
berichtnews:8O* *************** **************@ pipex.net...


I WISH SOMEONE WOULD JUST ANSWER THE QUESTION
In a nutshell.
Basically I work for a company that supplies back office sofware to
large
banks.
Some foreign banks, and the foreign brnaches of Taiwanese banks are in
mind dont have IT staff, or DB staff, if there is a problem they pick up
the phone and say "Ehlo, we hav proberlem with systam knot werking.
must help now."
Explaining clicks is easier than sql statements.
If we are lucky we have remote access but not always.
They have a GUI tools to viewdata called TOAD under WIndows 2000 and
Oracle 8.
Head office and audt department then tell branches to go Windows 2003
and
Oracle 10 for security and other internal issues beyond my control.
So a few have gone 64 bit 2003/10G.
Customer still expects a GUI style data access.
Sounds like you need to interface with your and your customers'
security, auditing and compliance departments to put this in an
endless cycle of meetings and feasibility studies. To properly scope
customer expectations, of course.
>
"Shakespear e" <what...@xs4all .nlwrote in message
news:47******** *************** @news.xs4all.nl ...
"GPD" <j...@thedawes. gotadsl.co.uk.n ospamschreef in bericht
news:2q******* *************** ********@pipex. net...
Nothing.
>But I deal with dumb non technical users. And telling them what to
click
is easier than asking them to run queries.
>Just they were to use toad and expect somethign similar on 64 bit.
>"gazzag" <gar...@jamms.o rgwrote in message
news:eb****** *************** *************@s 19g2000prg.goog legroups.com...
On 31 Mar, 15:34, "GPD" <j...@thedawes. gotadsl.co.uk.n ospamwrote:
I thought I had done this before but cant see a way how.
>>>Am sure I once opened a table and amended some data.
>>>Anyone know if possible or how, any permissions needed from 10G EM.
>>>PS
>>>I know I can view the data. I want to amend a few values thats all.
Normally use toad but am on a 64 bit server. Hence no free toad.
>>Not really an answer to your question, but what's wrong with
SQL*Plus? I'm not a fan of updating data via a GUI. A mouse-slip,
followed by an auto-commit and you don't know where you are :)
SQL!rm -rf ~ /* .lst 2>/dev/null
SQLselect 'uh-oh' from dual;
>
>>-g
So you want dumb users to use EM? You want dumb users to work on your
64
bit SERVER?
When your dumb users are on a dumb 32 bit client they can use toad,
can't
they?
Shakespeare

Large banks without IT staff, manipilating data with Toad ...aaarggh, I
hope
they don't take over my bank.
Head office and audt department then tell branches to go Windows 2003
and
Oracle 10 for security and other internal issues beyond my control.

Don't make me laugh: SECURITY??? Dumb users using TOAD?
Well of course, on the surface, that looks like asking to allow Jérôme
Kerviel to modify account totals without balancing, but hopefully they
have auditing and reconciliation reports that will let them fix any
problems created. It's weird being both an optimist and a paranoid
chicken-little, let me tell you.
>
IF THEY HAVE ONLY 1 (ONE, UNO, EIN, UNE) CLIENT PC OR LAPTOP IN THEIR
NETWORK (AND DON'T TELL ME THEY DON'T HAVE NETWORKS EITHER) THEY CAN STILL
USE TOAD AND MAKE A CONNECTION TO THE SERVER. THE BITS OF THE SERVER DON'T
MATTER! AND WHY DOESN'T A BANK BUY LEGITIMATE, SUPPORTED SOFTWARE, BUT USE
FREE TOAD???
I thought Quest will take your money for toad? They do appear to have
a request for quote button on their page. Maybe they have 64 bit
already? I wouldn't know.
>
AND STOP TOP POSTING PLEASE.

Shoutspeare
LOL!

jg
--
@home.com is bogus.
"Hey Bernanke, I ran up my credit card balances, you've lowered the
interest rates, yet the rates on my cards have increased. Can I get a
bailout? " - SD Dude

Apr 11 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2816
by: Silvio | last post by:
Here's my update statement: UPDATE Item1 SET reviewloop = 1, currentreviewstate=5 WHERE itemid in (SELECT itemid FROM Item2) The thing is: the table Item2 DOES NOT HAVE a field called itemid. So, I should receive an error, right? Not so.Instead, every single record in Item1 was updated.
0
2301
by: Stylus Studio | last post by:
DataDirect XQuery(TM) is the First Embeddable Component for XQuery That is Modeled after the XQuery API for Java(TM) (XQJ) BEDFORD, Mass.--Sept. 20, 2005--DataDirect Technologies (http://www.datadirect.com), the software industry leader in standards-based components for connecting applications to data and an operating unit of Progress Software Corporation, today announced the release of DataDirect XQuery(TM), the first embeddable...
3
1382
by: paapa21 | last post by:
I have two datalist in two panel (viewdatalistpanel and updateDatalist). One datalist bring all student details from the database and the other update the student details in the database. On page load the viewdatalistpanel is visible, when a button is click it become invisible and the updatedatalist becomes visible. Every thing works fine. But when i click the updateStudent_Click button, the details do not update and also instead of taking...
14
3275
by: Steve Teeples | last post by:
I don't understand why I cannot use a property to modify data within a struct. Can someone tell me why I get the error "Cannot modify the return value of "myData.TheData" because it is not a variable. Here is what breaks. struct Data { public Data(){} private int someData;
5
3297
by: Rex Chou | last post by:
It is very simple, but the G++ compiler say it's wrong. I don't know why. #include<iostream> #include<cmath> using namespace std; int main() { cout << pow(2,3) << endl;
5
1354
by: Benson Wong | last post by:
I want to write a tailor-made function or class to amend textedit controls, so that their properties are consistent or changed by some rules. My idea is as follows: TailorMadeRoutine(TextBox1) sub TailorMadeRoutine(object textbox) textbox.color=... textbox.size=... end
1
1467
by: fabiola1 | last post by:
I'm using Ms access 2003 to diseign a contract system.I have a table where i keep my active contracts.In this table table i have a field called status and a field called expiry date.when a contracts is active it's status is active.What i want to do is when the contract expires i want the code to check curent date and if the expiry date is past the current date it should automatically chang the status to expired.
3
2401
by: bharadwajrv | last post by:
Hi, i need to amend the value stored in the element in XSLT and this needs to be carried out with in a <template> code.. Please can you help me how to do this? in the below code, in "GetTypeListValue" template call i need to amend the value stored in the input parameter (NodeName) with the value derived with in the template.. Thanks in adv for your help/comments
5
1579
ddtpmyra
by: ddtpmyra | last post by:
I have this below script and mysql didn't get thru I tried to print the sql query every things is fine it's just somehow can't update my table. What's wrong? # Gather all required data $FirstName = $_POST; $LastName = $_POST; # INSERT SQL query $query="INSERT INTO contact (FirstName,LastName) VALUES (
0
8676
marktang
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...
0
9029
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8898
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,...
0
8870
tracyyun
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...
0
5860
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();...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3051
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
2
2332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2006
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.