Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert and delete

just a DBAFeb 26 2013 — edited Feb 27 2013
I would like to clarify the situation.

1. create table t1 as select * from t2.
2. delete from t1.

Why second statement is several times slower than insert if it just moves the same amount of data into undo segments ?
This post has been answered by Jonathan Lewis on Feb 27 2013
Jump to Answer

Comments

843804
Extend your own JTextArea :)
843804
import java.awt.*;
import java.awt.geom.*;
import java.awt.image.*;
import java.io.*;
import java.net.*;
import javax.imageio.*;
import javax.swing.*;
import javax.swing.border.*;

public class CentredBackgroundBorder implements Border {
    private final BufferedImage image;

    public CentredBackgroundBorder(BufferedImage image) {
        this.image = image;
    }

    public void paintBorder(Component c, Graphics g, int x, int y, int width, int height) {
        x += (width-image.getWidth())/2;
        y += (height-image.getHeight())/2;
        ((Graphics2D) g).drawRenderedImage(image, AffineTransform.getTranslateInstance(x,y));
    }

    public Insets getBorderInsets(Component c) {
        return new Insets(0,0,0,0);
    }

    public boolean isBorderOpaque() {
        return true;
    }

    //demo
    public static void main(String[] args) throws IOException {
        JFrame.setDefaultLookAndFeelDecorated(true);
        JTextArea area = new JTextArea();
        area.setForeground(Color.GREEN);
        area.setOpaque(false);
        area.read(new FileReader("CentredBackgroundBorder.java"), null);
        String url = "http://today.java.net/jag/bio/JagHeadshot.jpg";
        JScrollPane sp = new JScrollPane(area);
        sp.getViewport().setOpaque(false);
        sp.setViewportBorder(new CentredBackgroundBorder(ImageIO.read(new URL(url))));

        JFrame f = new JFrame("BackgroundBorderExample");
        f.getContentPane().add(sp);
        f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        f.setSize(600,400);
        f.setLocationRelativeTo(null);
        f.setVisible(true);
    }
}
843804
Thank you for your help !!^^
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2013
Added on Feb 26 2013
10 comments
722 views