Community Tips

SORA regularly publishes community tips! – If you have a tip you want to share, click on the button on the right!

Submit Community Tip

swissouc

👩‍💻 SORA's Tip #100 Database design flaw

👩‍💻 SORA's Tip #100

Database design flaws will have an impact on its performance!

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #99 Remember that SYSDATE

👩‍💻 SORA's Tip #99

Remember that SYSDATE returns the time and date of your DBs operating system!

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #98 If you do not have ref

👩‍💻 SORA's Tip #98

If you do not have referential integrity enforced within the database you have almost certainly got damaged data.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #97 If your data is import

👩‍💻 SORA's Tip #97

If your data is important to you then you need to design your database: having an ERD is fundamental.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #96 Performance tuning yo

👩‍💻 SORA's Tip #96

Performance tuning your database without an ERD is like trying to drive a car by steering with your knees.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #95 If you have no ERD, do

👩‍💻 SORA's Tip #95

If you have no ERD, do you really know your data?

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #94 Brook's Law (1975) sti

👩‍💻 SORA's Tip #94

Brook's Law (1975) still applies today: "Adding manpower to a late software project makes it even later."

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #93 Stop using parameter S

👩‍💻 SORA's Tip #93

Stop using parameter SERVICE_NAMES as it is deprecated. Use DBMS_SERVICE package or srvctl CLI instead.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #92 PDB default service sho

👩‍💻SORA's Tip #92

PDB default service should only be used for administrative tasks.

#SwissOUC #CommunityTips

👩‍💻 SORA's Tip #91 Always specify the col

👩‍💻 SORA's Tip #91

Always specify the columns in INSERT statements!

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #90 The WHERE-clause filter

👩‍💻SORA's Tip #90

The WHERE-clause filters data before aggregations are applied. To filter aggregationsuse the HAVING clause.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #89 Table aliases can help

👩‍💻SORA's Tip #89

Table aliases can help you write less when doing JOINS, they also improve your codes readability.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #88 Instead of using long d

👩‍💻SORA's Tip #88

Instead of using long data value lists in your IN keyword, think about if you can solve it with a JOIN.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #87 Avoid WHERE clauses wit

👩‍💻SORA's Tip #87

Avoid WHERE clauses with functions when writing SQL statements.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #86 Do one change at a time

👩‍💻SORA's Tip #86

Do one change at a time - don't change multiple things at once.

#SwissOUC #CommunityTips

👩‍💻SORA's Tip #85 After applying a patch

👩‍💻SORA's Tip #85

After applying a patch to your database verify if your performance workarounds are still required (e.g. Hints, Profiles).

#SwissOUC #CommunityTips

SORA's Tip #84 If you start fixing a broken syste

SORA's Tip #84

If you start fixing a broken system, take a backup of the broken system first.

#SwissOUC #CommunityTips

SORA's Tip #83 Agree on a set of coding guideline

SORA's Tip #83

Agree on a set of coding guidelines with your team.

#SwissOUC #CommunityTips

SORA's Tip #82 Write down the things you learn!

SORA's Tip #82

Write down the things you learn!

#SwissOUC #CommunityTips

SORA's Tip #81 Make sure Grants and Synonyms are

SORA's Tip #81

Make sure Grants and Synonyms are created after deploying changes!

#SwissOUC #CommunityTips #sql

Load More... Follow on Instagram

Meet SORA

Subscribe

Swiss Oracle User Community

Swiss Oracle User Community ·
@swissOUC

💬Call to our Swiss / German-speaking bubble:

👩‍🏫Do you want to pass on your #database knowledge to the next generation?

🎓The University of Applied Sciences of Northwestern Switzerland is looking for a lecturer for databases:
https://t.co/HxZXIIPdgY

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community ·
@swissOUC

🃏🎲Today 20:00 CET the next #TechPubQuiz will take place. 🎙

Enough time to register and fill your fridge! 🥂🍺🥛
🔽
https://t.co/WYD1JsORBF

#OracleBeerBern #SwissOUC @oracleace

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community ·
@swissOUC

📆Two more days until the 8th edition of #OracleBeerBern #TechPubQuiz takes place!

🚀We are ready and are looking forward to having a great #QuizTime!

✏If you didn't register yet, you still can sign up on the #Meetup page!
🔽
https://t.co/WYD1Jsxgd5

#SwissOUC https://t.co/o6Zo27NC7m

View on Twitter

Swiss Oracle User Community

Swiss Oracle User Community ·
@swissOUC

🥳 Congrats to @pdevisser for submitting question 100!

We're really looking forward to next weeks #Techpubquiz! 🃏

If you have not registered, go do it! ⬇️
https://t.co/WYD1JsPprd https://t.co/UV82enDvxf

View on Twitter

Swiss Oracle User Community@swissOUC
❤Wow! We already received 95 questions for #OracleBeerBern #TechPubQuiz! 🤩🤯

Who will submit question 100?

✏💬Submit your question here🔽
https://t.co/EiOTC4Iixc

#SwissOUC

Swiss Oracle User Community

Swiss Oracle User Community ·
@swissOUC

❤Wow! We already received 95 questions for #OracleBeerBern #TechPubQuiz! 🤩🤯

Who will submit question 100?

✏💬Submit your question here🔽
https://t.co/EiOTC4Iixc

#SwissOUC

View on Twitter