Md. Ahsan Habib

Freelance Photoshop Editor | Oracle Apex Developer | Instructor

[Md. Ahsan Habib @shezan00]

#Advanced #photoshop #editing #services. Check out here.
https://t.co/wagktl0ZPY

[Md. Ahsan Habib @shezan00]

Do you remember when you joined Twitter? I do! #MyTwitterAnniversary

[Md. Ahsan Habib @shezan00]

Check out my Gig on Fiverr: do advanced Photoshop editing for Amazon product photos https://t.co/6JpSJpgSZG

#photoshop #imageediting #Amazon #PushpaTheRule #11YearsWithEXO #Eterna11oveForEXO #LoveIsBlind
#productphotoeidting #photoshop_art #manipulation

[Louis Moreaux @moreaux_louis]

Monday's Tip for Oracle APEX:
Want to keep your custom CSS in a separate file, but have trouble managing page-specific rules?

Here's how to do it properly? 🧵

#orclAPEX
1/4

[Connor on SQL and Database @connor_mc_d]

Here's a guide to all of that... and design .... and advanced topics.... And its all free
https://t.co/ImguG2qlvD

[Md. Ahsan Habib @shezan00]

@Upwork Md. Ahsan Habib
Photoshop Expert & Oracle Apex Developer.

[SQL Daily @sqldaily]

Want to get your #SQL query results as CSV, JSON or INSERT statements?

Do this in @OracleSQLDev by adding the format as a comment to the statement

For example

SELECT /*csv*/ ...

Then run the query in script mode (F5 by default)

This also supports XML, HTML, and fixed-width

[SQL Daily @sqldaily]

Want to find all the DML changes to a table in a period?

Do this in Oracle Database with

select ... from ...
VERSIONS BETWEEN TIMESTAMP
<start> AND <end>

Use the VERSIONS_* pseudo columns to find the what & when

As with flashback query, the default is 15 mins of changes

[Md. Ahsan Habib @shezan00]

Check it out! shezan00 will edit and design amazon product photo for $10 on #Fiverr https://t.co/wg10kakrev

[SQL Daily @sqldaily]

Get the top or bottom value in an ordered data set with FIRST_VALUE & LAST_VALUE

But beware!

The default window for LAST_VALUE stops on the current row, NOT the last in the results!

To get the final value, set this to

ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING

[SQL Daily @sqldaily]

Use window functions to get running totals in #SQL

Just remember: the window is calculated after filtering

So placing the function in a subquery can give different results

e.g. these are not the same

select count () over () ...
from (
select count () over () ...
)
where ...

[Md. Ahsan Habib @shezan00]

Nice #SQL

[SQL Daily @sqldaily]

Turn columns back to rows in #SQL in Oracle Database with

UNPIVOT (
value_col FOR col_names IN ( c1, c2, ... )
)

This turns the IN-list columns into two

value_col => their values
col_names => their names

By default it omits null-valued cols. Add

INCLUDE NULLS

to show them

[Sergei Martens @sergeimartens]

The official APEX World 2021 conference App (developed with Oracle APEX) is now available in both App Stores!

Apple: https://t.co/EoSDEYLYeE
Android: https://t.co/bcoOOVY8Lg

#APEXWorld2021 #orclapex #apexworld #nlOUG

[Md. Ahsan Habib @shezan00]

Check out Diploma in Web Design on https://t.co/PhJ2OxKCHa https://t.co/p3dCBv8dmZ

[Md. Ahsan Habib @shezan00]

Check out Diploma in Web Design on https://t.co/PhJ2OxKCHa https://t.co/p3dCBv8dmZ

[Md. Ahsan Habib @shezan00]

PREMIUM Quality Product Photo Editing.
Check out here: https://t.co/SZ8dACXVQl

#photoediting #adobephotoshop #photography #Infographics #graphicdesign #beforeandafter #PhotoOfTheDay #images #editing

[Md. Ahsan Habib @shezan00]

Check out my Gig on Fiverr: do advanced photoshop editing
https://t.co/XeZGyGhWtM

#photoediting #adobephotoshop #photography #Infographics #graphicdesign #beforeandafter #PhotoOfTheDay #images #editing #SUGA1BillionStreams #MIvRCB #FearlessTaylorsVersionOutNow
#Freelancers

[Md. Ahsan Habib @shezan00]

Check it out! shezan00 will do advanced photoshop editing for amazon product for $15 on #Fiverr https://t.co/kqRFPuaVJG

[Md. Ahsan Habib @shezan00]

Check out my Gig on Fiverr: do advanced #photoshopediting for #amazon #productphoto https://t.co/fvg1Qsifgo

#photoediting #adobephotoshop #photography #Infographics #graphicdesign

[Md. Ahsan Habib @shezan00]

Check out my Gig on Fiverr: do advanced photoshop editing for amazon product photo https://t.co/NnfmZeq77Z

[Md. Ahsan Habib @shezan00]

Check out my Gig on Fiverr: do advanced photoshop editing for amazon product photo https://t.co/KWurmv1t2l