Getting back the dropped table back in ORACLE

You can get back the dropped table in ORACLE . To do so checkout FLASHBACK command.
Here is a example below :

First of all create a table.I am creating  a table with name First_Table.
"CREATE  table First_Table(name varchar(20),id varchar(10))"

Then DROP the table using DROP command like this: DROP table First_Table

And here comes the magic command to get back the dropped table:
FLASHBACK TABLE  First_Table TO BEFORE DROP;

Comments

Post a Comment

Popular posts from this blog

Arrays.sort() and Collections.sort() NullPointerException

While sorting an array by using Arrays.sort()  or using Collections.sort() for sorting a list you can encounter a NPE (NullPointerException) . You might be thinking what went wrong ? So one of element in the array which have been  passed for sorting contains the null element. Similar with the list case also .So check for a null entry in your array or list before passing to these methods as parameter. Example 1 : String[] strarr={"abc", "def" , null}; Arrays.sort(strarr); Output 1: -------- Exception in thread "main" java.lang.NullPointerException at java.lang.String.compareTo(String.java:1167) at java.lang.String.compareTo(String.java:92) at java.util.Arrays.mergeSort(Arrays.java:1144) at java.util.Arrays.sort(Arrays.java:1079) at Test.main(Test.java:7) Example 2: List strlist=new ArrayList (); strlist.add("abc"); strlist.add("def"); strlist.add(null); Collections.sort(strlist); Output 2: ----------
Read more

org.xml.sax. SAXParseException: Element type "web-app" must be declared.

Sometime you will notice these kinds of error messsges while deploying your web application to Tomcat.  org.apache.commons.digester.Digester - Parse Error at line 22 column 18: Element type "web-app" must be declared. org.xml.sax.SAXParseException: Element type "web-app" must be declared. at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:1213) at org.apache.xerces.validators.common.XMLValidator.reportRecoverableXMLError(XMLValidator.java:1807) at org.apache.xerces.validators.common.XMLValidator.validateElementAndAttributes(XMLValidator.java:3633) at org.apache.xerces.validators.common.XMLValidator.callStartElement(XMLValidator.java:1229) at org.apache.xerces.framework.XMLDocumentScanner.scanElement(XMLDocumentScanner.java:1806) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:949) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381) at org
Read more

Sentimental Analysis : PART 1

Sentimental Analysis refers to identify, extract, quantify, and study affective states and subjective information. It helps to identify public emotion about certain topics/products. Humans are fairly intuitive when it comes to interpreting the tone of a piece of writing, but teaching a machine to identify emotion is tough. A negative sentence can be assumed by machine as positive.  For example, In case of sarcastic sentence "I have lost my watch again. That's brilliant", humans can easily tell that it's a negative emotion framed in sarcasm but machine can assume that it's a positive sentence without knowing the context. Applying the contextual information, machine can identify it to be negative emotion. Sentimental Analysis helps to gain insight from social data and to understand the consumer attitude and act accordingly.  VOC(Voice Of The Customer) applications are primarily used by companies to determine what a customer is saying about a product o
Read more