venushuynh.wordpress.com

Make it count

Don’t do that in PL/SQL. 1Declare variables as VARCHAR2(N). Use %TYPE instead of VARCHAR2(N), unless it is a “single point defintion”. Incase the variable stand for combine column, use SUBTYPE and define subtype at the declaration of the package in order to tuning. Overleading means we have more than 1 func/proc have the same name with different parameter lists (aka static polymorphism). 3Use low-level error handling logic. 8216;t call RAISE ERROR APPLICATION/ explicitly. Func in each handler. 2Apply arc...

http://venushuynh.wordpress.com/

OVERVIEW OF venushuynh.wordpress.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR VENUSHUYNH.WORDPRESS.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.4 out of 5 with 17 reviews

5 star

9

4 star

6

3 star

2

2 star

0

1 star

0

Hey there! Start your review of venushuynh.wordpress.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT VENUSHUYNH.WORDPRESS.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

10

SSL

EXTERNAL LINKS

0

SITE IP

192.0.78.12

LOAD TIME

0.516 sec

SCORE

6.2

PAGE TITLE

Make it count | venushuynh.wordpress.com Reviews

<META> DESCRIPTION

Don’t do that in PL/SQL. 1Declare variables as VARCHAR2(N). Use %TYPE instead of VARCHAR2(N), unless it is a “single point defintion”. Incase the variable stand for combine column, use SUBTYPE and define subtype at the declaration of the package in order to tuning. Overleading means we have more than 1 func/proc have the same name with different parameter lists (aka static polymorphism). 3Use low-level error handling logic. 8216;t call RAISE ERROR APPLICATION/ explicitly. Func in each handler. 2Apply arc...

<META> KEYWORDS

1 make it count

2 start here

3 2overload lazily

4 use generic

5 5write spaghetti code

6 leave a comment

7 redo logs recovery

8 2 options

9 check alert log

10 solution

CONTENT

Page content here

KEYWORDS ON PAGE

make it count,start here,2overload lazily,use generic,5write spaghetti code,leave a comment,redo logs recovery,2 options,check alert log,solution,shutdown immediate;,startup;,start up;,recovering non critical datafiles,recovering critical datafiles,begin

SERVER

nginx

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Make it count | venushuynh.wordpress.com Reviews

https://venushuynh.wordpress.com

Don’t do that in PL/SQL. 1Declare variables as VARCHAR2(N). Use %TYPE instead of VARCHAR2(N), unless it is a “single point defintion”. Incase the variable stand for combine column, use SUBTYPE and define subtype at the declaration of the package in order to tuning. Overleading means we have more than 1 func/proc have the same name with different parameter lists (aka static polymorphism). 3Use low-level error handling logic. 8216;t call RAISE ERROR APPLICATION/ explicitly. Func in each handler. 2Apply arc...

INTERNAL PAGES

venushuynh.wordpress.com

1

Don’t do that in PL/SQL « Make it count

https://venushuynh.wordpress.com/2011/12/30/dont-do-that-in-plsql

Raquo; Don’t do that in PL/SQL. Don’t do that in PL/SQL. 1Declare variables as VARCHAR2(N). Use %TYPE instead of VARCHAR2(N), unless it is a “single point defintion”. Incase the variable stand for combine column, use SUBTYPE and define subtype at the declaration of the package in order to tuning. Overleading means we have more than 1 func/proc have the same name with different parameter lists (aka static polymorphism). 3Use low-level error handling logic. 8216;t call RAISE ERROR APPLICATION/ explicitly.

2

Restore and Recovery Tactics « Make it count

https://venushuynh.wordpress.com/2014/11/12/restore-and-recovery-tactics

Restore and Recovery Tactics. Control Files: what if we lost all control files. Create control files from scrash. The good practise for this case is everytime we change DB structure - Backup control file to trace. Alter database backup controlfile to trace as ‘c: oracle product control bk.sql’. 8211;In this file, we can find sql to create controlfile. With this case, database will startup no mount. Alter database open;. Case : Steps need to process when system corrupts. 1Get the lastest backup to restore.

3

FIRST_ROWS vs. ALL_ROWS and ROWNUM predicate « Make it count

https://venushuynh.wordpress.com/2014/10/07/first_rows-vs-all_rows-and-rownum-predicate

Raquo; FIRST ROWS vs. ALL ROWS and ROWNUM predicate. FIRST ROWS vs. ALL ROWS and ROWNUM predicate. Http:/ dioncho.wordpress.com/2009/01/30/89/. October 7, 2014. Managing Sessions From a Connection Pool in Oracle Databases. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. Originally posted on Richar...

4

About « Make it count

https://venushuynh.wordpress.com/about

My name is ChauHuynh from Ho Chi Minh city, Vietnam. I’m an Oracle developer and I use this page to storage my tech notes and share experiences😀. Create a free website or blog at WordPress.com. Follow “Make it count”. Get every new post delivered to your Inbox. Build a website with WordPress.com.

5

Managing Undo Segment « Make it count

https://venushuynh.wordpress.com/2014/10/31/managing-undo-segment

Raquo; Managing Undo Segment. Undo segment is used to remember data before modifing, for rollback or do other thing. For case DB is interupted. Step1: we get the lastest backup and restore ( —– move backward). Step2: we apply REDO segment (—– move forward to the point when DB is is interupted). But redo doesn’t know what data is commit or uncommit. Step3: we apply undo segment to get commit DB ( – abit backward). Using Flashback query: select data @ a paticular point and time. Then undo is out of space, ...

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

OTHER SITES

venushum.bandcamp.com

Music | Venus Hum

Apollo 11: The First Lunar Landing (Soundtrack). Meet the New Mozart (single). The Colors In The Wheel. Switched on Christmas [special edition]. Switch to mobile view.

venushum.com

Venus Hum

FRESHLY RENOVATED VERSIONS OF YOUR FAVORITES.

venushumancapital.com

Venus Human Capital | We are a distinctive business consultancy established to meet the growing demand for high quality, practitioner-led management and human capital advisory services.

What We Can Do For You. Commitment to Quality is the Biggest Promise that We Make to Our Valued Clients. We Have Expertise in the Development of Company Vision, Mission Statement, KPIs and key Organizational Competencies. Our Service is Focused on Enhancing the Overall Capability of Your Organization. WE ARE A DISTINCTIVE BUSINESS CONSULTANCY ESTABLISHED TO MEET THE GROWING DEMAND FOR HIGH QUALITY, PRACTITIONER-LED MANAGEMENT AND HUMAN CAPITAL ADVISORY SERVICES. Request for a Quotation.

venushumpsmars.com

VHM

You Can’t Make This Shit. Unfortunately, we do not have any events scheduled at this present time. Please continue to check back with us for future events. VenushumpsMars.com Is Under Construction! No Worries…Soon Come! LOVE is the ultimate power. LOVE is the fountain of youth of emotion. Whatever. LOVE is being real with each other and being able to understand. LOVE shouldnt be forced. It should be something given EFFORTLESSLY. - VHM. I still dont understand it. Im not even going to try. -VHM. Terms of ...

venushunt.blogspot.com

V Ê N U S H U N T

Sexta-feira, 6 de abril de 2012. A gente acaba em mim. Que sou eu o fim. Não controlo meu jeito barroco. Não acho medida para abraço oco. Não sirvo e sou pouco. E meu banho ainda é gelado. Meu leito te torna cansado. Meu beijo ficou aguado. Não quero mais pagar pra ver. E o que deu pra ser, sabe Deus porquê. Foi na hora errada. Este texto faz parte do grupo do fins e foi escrito há cerca de 10 meses. Resgatado e finalizado apenas hoje.). Segunda-feira, 2 de abril de 2012. Elegia de um dia. Pablo chutava ...

venushuynh.wordpress.com

Make it count

Don’t do that in PL/SQL. 1Declare variables as VARCHAR2(N). Use %TYPE instead of VARCHAR2(N), unless it is a “single point defintion”. Incase the variable stand for combine column, use SUBTYPE and define subtype at the declaration of the package in order to tuning. Overleading means we have more than 1 func/proc have the same name with different parameter lists (aka static polymorphism). 3Use low-level error handling logic. 8216;t call RAISE ERROR APPLICATION/ explicitly. Func in each handler. 2Apply arc...

venushydroline.com

Index of /

venushygiene.com

Welcome To Venus Hygiene

ISO 9001:2008 Certified Company. Home RO water purifier. Institutional RO water purifier.

venushypno.com

Venus Hypno

This site contains material which is adult in nature. Do not enter unless you are 18 years of age or older. By clicking this link you are guaranteeing you are an adult.

venushypnotherapy.org

VenusHypnotherapy

Do you have health challenges, emotional challenges, or feel that your current situation is not what you want it to be? Then there are reasons for you reading this page, deep down in you, you want to reach out for change, to free your emotional. My name is Venus Chau. I am very happy to meet with you here. I am a Consulting Hypnotist certified through the National Guild of Hypnotists, Reiki master, and meditation practitioner. I believe change and healing are started from within. Website: http:/ venushyp...

venusi.com

Venusi.com - Ready For Development

Contact Us for Details. Want to own venusi.com? Brand your new business, product, service, or blog. Buy the domain and develop it yourself or get our e-Inclusive web package. Free for 6 months) and immediately have a developed website, email, hosting, and support. Contact us for a free quote. Choose Domain Only, Web Packages, or Other Services. A complete solution for getting your new online business started. We offer various Web Solutions, whether you want a Complete Web Package or the Domain Only.