SQL Triggers in Oracle -


मेरा प्रश्न इस प्रकार है:

उपयोगकर्ता नाम = व्यवस्थापक

जब भी मैं किसी तालिका "ए" पर एक डालें / अपडेट / हटाए जाने के कार्य निष्पादित करें मुझे एक ऐसा ट्रिगर होना चाहिए जो टेबल "b" में उपयोगकर्ता नाम डालें

क्या यह संभव है?

<पूर्व> प्रत्येक पंक्ति के लिए ए पर सम्मिलित या अपडेट या हटाए जाने या हटाने से ट्रिगर audit_a_trg को बदलना या बदलने के लिए b मान (उपयोगकर्ता) में डालें; समाप्त; /

ओरेकल का ऑनलाइन प्रलेखन बहुत अच्छा है आप एसक्यूएल संदर्भ पढ़ सकते हैं

संपादित करें

उपयोगकर्ता एक ऐसा कार्य है जो खाते का नाम देता है जो डीएमएल को जारी करता है ।


Comments

Post a Comment

Popular posts from this blog

.net - C# List<T>.Find(x=>x.Rectangle.Contains(Point)) FAIL -

For my life, I can not understand why this code generates the following output ... I think there is a bug or something while using the list and lambda, if type one rectangle exposes the property and you use the included method of rectangle object ... and the clear statement proves true while Find list method fails .... Onway Code Public Gridskeyr Warldtokapadsb (Point location) {location = _Map.WorldToClient (location); Gridsquare gs = this.find (x => x.Rectangle.Contains (location)); GridSquare KP = G.Find (X => X. laxative canteen (location)); & Lt; GridSquare & gt; List = kp.FindAll (x => x.Rectangle.Contains (location)); U.dp (list.Count); Gridskare sub = KP.Fid (X => X. laxative canteen (location)); If (sub == faucet) {u.dp (place to look for "location"); U.dp ("The location found in the grid category" + GS toaster ()); U.dp ("Grid Square Bounds" + gs.Rectangle.ToString ()); U.dp ("location found in keypad" +...
Read more

iphone - Smoothing a rounded stroke in Core Graphics -

I am making my own UITableViewCells with a gradient background. I have worked all the logic and drawing, but the one that I want to fix is ​​"chunky" around the corners of my custom cell: If you have corners, you See what I'm talking about. Here is the code that I am using to generate cells: CGCTXT C = UigRxGroupCertexConnect (); CGColorSpaceRef myColorSpace = CGColorSpaceCreateDeviceRGB (); CGGradientRef myGradient = Zero; CGFloat component [8] = TABLE_CELL_BACKGROUND; CGContextSetStrokeColorWithColor (C, [[UAColor colorWithWhite: 0.7 alpha: 1] CGColor]); CGContextSetLineWidth (C, 2); CGContextSetAllowsAntialiasing (C, Yes); CGContextSetShouldAntialias (C, Yes); CGFloat minx = CGRectGetMinX (RECT), MIDX = CGRactgetMIDX (RECT), MAX x = CGTXxX (RECT); CGFloat miny = CGRectGetMinY (Rect), maxy = CGRectGetMaxY (rect); CGMutablePathRef Path = CGPathCreateMutable (); CGPathMoveToPoint (path, NULL, minx, miny); CGPathAddArcToPoint (default margin of path, NULL, mix, ...
Read more

Best practice for URL redirection in ASP.NET web application -

I have an asp page (Default.aspx) that shows the difference between two text files. It has two drop down lists (respectively id = "file1" and "file2" respectively) and a button (id = "submit"). There is also a lexical control with the id "result". The content of the list button is populated based on the files present in the physical application path. Each time the submit button is clicked, I want to give the result of diff / comparison in literal control, so I have an event handler like this: protected Zero Submit_Click (Object Sender, EventArgs e) {Results.First = Comparison Files (File 1. Selected Price, File2.SelectedValue); } The problem with this is that you can not bookmark results of comparison between specific files. To solve this problem, I compare the values ​​of the selected files as a query string for the added URL and made a redirection. And so, the above event handler has been changed to look like this: Protecte...
Read more