This is the second note in the TypeScript series. In this post, we will explore the fundamentals of TypeScript.
essay
Beginners notes about TypeScript: Part 2
essay
Beginners notes about TypeScript: Part 1
Programming languages can generally be categorized into two types: dynamically typed and statically typed...
essay
Codbix No.7
Welcome to Issue #7 of The Codbix! This week: Habits of great software engineers, Decision Making at Netflix and How to get your brain to focus.
essay
Codbix No.6
Welcome to Issue #6 of The Codbix! This week: Use code visibility to illuminate unfamiliar code, Laravel community and How to Get Your Brain to Focus.
essay
Hugo image shortcode
This website is built with Hugo, a static site generator that uses Markdown for writing content files...
notes
Display refresh rate
The refresh rate of a display is the number of times per second that the image refreshes on the screen. For example, a 60Hz display will update the screen 60 times per second.
References
essay
Hugo alert box shortcode
If you are using Hugo as your static site generator, you might want to create a card shortcode that can display different types of information on your blog posts...
essay
Hugo Custom Shortcodes
Writings comments in the code will help you and anyone who reads the code by giving more readability and understandings.
notes
PL SQL Constraints
To find the constraints in a table
ALL_CONSTRAINTS: Provides information about all constraints accessible to the user, across all tables in the database. It includes constraint types, status, and more, but doesn’t show column-specific details.
SELECT * FROM ALL_CONSTRAINTS
WHERE TABLE_NAME='YOUR_TABLE_NAME'
AND OWNER = 'OWNER_NAME';
To find the constarints referring to a table.
SELECT * FROM ALL_CONSTRAINTS
WHERE R_CONSTRAINT_NAME IN (
SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS
WHERE TABLE_NAME='YOUR_TABLE_NAME'
)
AND OWNER = 'OWNER_NAME';
USER_CONS_COLUMNS: Shows details about columns associated with constraints for tables owned by the current user. It’s useful for checking specific columns involved in constraints like primary keys, foreign keys, or unique constraints.
SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, POSITION
FROM USER_CONS_COLUMNS
WHERE TABLE_NAME = 'YOUR_TABLE_NAME';