Deepak Timsina

Oracle SQL • PL/SQL • Oracle Database • Linux • Reader

[Deepak Timsina @imdeepaktimsina]

Read Only table in #Oracle
#PLSQL

Here 3 methods to achieve this functionality.

A Thread🧵

[Deepak Timsina @imdeepaktimsina]

Absolutely right!

[Shreyamishraa... @shryexe]

Your personal website is the new resume

[Deepak Timsina @imdeepaktimsina]

@himani_0507 4. PostgreSQL

[Deepak Timsina @imdeepaktimsina]

@shryexe Still figuring out 😜

[Deepak Timsina @imdeepaktimsina]

🙌

[Reads with Ravi @readswithravi]

“I am a slow walker, but I never walk back.”

— Abraham Lincoln

[Deepak Timsina @imdeepaktimsina]

@readswithravi You're right Ravi... Honestly it works!

[Deepak Timsina @imdeepaktimsina]

@quotetoponder Yup.. Be good human being first!

[Deepak Timsina @imdeepaktimsina]

@MakadiaHarsh Great Harsh!

[Deepak Timsina @imdeepaktimsina]

@ValaAfshar Great sir!

[Deepak Timsina @imdeepaktimsina]

@hvgoenka Great sir... Thanks for sharing it!

[Deepak Timsina @imdeepaktimsina]

Career mein growth sirf hard work se nahi, smart learning se bhi aati hai. 📚

रोज़ थोड़ा सीखो, अपनी सोच बेहतर बनाओ और खुद को कल से बेहतर बनाओ।

Success overnight nahi milti, but daily improvement ek din zaroor result deti hai. 💯

#CareerGrowth #Learning #Technology

[Deepak Timsina @imdeepaktimsina]

In Oracle EBS, understanding table relationships is just as important as writing SQL.

For example, in Inventory:
📌 MTL_SYSTEM_ITEMS_B — Item master
📌 MTL_ONHAND_QUANTITIES_DETAIL — On-hand quantity details
📌 MTL_ITEM_LOCATIONS — Subinventory locator information

#sql

[Deepak Timsina @imdeepaktimsina]

🔹 Oracle EBS SCM Tip: SQL

In Oracle EBS, understanding the relationship between PO_HEADERS_ALL and PO_LINES_ALL is essential for Purchase Order reporting.

• PO_HEADER_ID links headers to lines.
• Use JOINs to retrieve PO details efficiently.

#OracleEBS #SQL #SCM

[SQL Daily @sqldaily]

From 23.26.2 you can nest WITH clauses in Oracle #SQL

@vahidusefzadeh walks through rewriting a plain SELECT to find total complete orders into nested WITH

WITH totals AS ( WITH completed AS ( ... ) SELECT completed ... )
SELECT totals ...

https://t.co/1EyDnOwolY

[Deepak Timsina @imdeepaktimsina]

ज़िंदगी में आगे बढ़ने के लिए सिर्फ़ मेहनत करना काफी नहीं है।

खुद को हर दिन थोड़ा बेहतर बनाना भी ज़रूरी है। 📚

नई skills सीखो, technology के साथ update रहो और अपनी गलतियों से सीखो।

Growth takes time, but consistency makes the difference.

#CareerGrowth #Learning #Technology

[Deepak Timsina @imdeepaktimsina]

🔹 Oracle EBS SCM Tip: SQL

In Oracle EBS, understanding the relationship between PO_HEADERS_ALL and PO_LINES_ALL is essential for Purchase Order reporting.

• PO_HEADER_ID links headers to lines.
• Use JOINs to retrieve PO details efficiently.

#OracleEBS #SQL #SCM

[Deepak Timsina @imdeepaktimsina]

Career mein growth sirf hard work se nahi, smart work aur continuous learning se bhi aati hai. 🚀

Books 📚 mindset badalti hain, technology 💻 opportunities badalti hai, aur consistency future banati hai.

Learn daily. Grow continuously. 🔥

#Learning

[SQL Daily @sqldaily]

You can't pass parameters to views

But with macros in Oracle AI Database you can create view-like objects that do have parameters

These received a big upgrade in 23.26.4 with macro objects:

CREATE MACRO ... IS SELECT ...

@ChrisRSaxon shows how https://t.co/mEGsPig5n2

[Dear Self. @Dearme2_]

Do it anyway.

[Harsh Makadia @MakadiaHarsh]

every manual process is a bet that your best person never takes a day off.

[that Jeff Smith @thatjeffsmith]

Previously on thatJeffSmith: I built a mini RAG Pipeline to answer Oracle questions https://t.co/HAI8dd8CmH