Friday, February 23, 2018

oracle 11g

  1. https://stackoverflow.com/questions/203469/how-to-use-enums-in-oracle
  2. https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT012
  3. https://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_6014.htm
  4. https://serverfault.com/questions/10477/differences-between-classes12-jar-ojdbc14-jar-ojdbc5-jar-and-ojdbc6-jar  
  5. http://www.oracle.com/technetwork/topics/jdbc-faq-090281.html 
  6. start oracle service in the services
  7. also start oraclexetnslistener service in the services
  8. create user  abc identified by xyz;
  9. grant dba to abc;
  10. select * from user_sequences;// to list all sequences
  11. drop sequence sequencename; //to drop  sequence
  12. do not forget to commit after each dml statement

No comments:

Post a Comment