#having clause in oracle

[seilnakyle]

do you have any dickbabs reading recommendations (especially if they're babs focused)? I read batgirl year one and some nightwing too, but I would love to delve deeper into their relationship

thank you sm in advance 🙏

They just don’t do slow burn in comics like Dickbabs anymore ♥️

If you’re coming right off batgirl year one (masterpiece. Redefined my life. Forever altered my brain) I definitely recommend you read Nightwing Year one as well, (starts at issue #101 of Nightwing (1996)

In this list I have included everything I can, but If I missed anything significant please feel free to let me know!

Pre-Crisis:

Detective Comics (1937): #359

The Batman Family (1975): #1, 2, 3, 5, 7, 9, 10, 11, 12, 13, 14, 15, 16, 20

POST CRISIS:

Robin Year One (2000): #4

Batgirl Year One (2003)

Nightwing Year One - Nightwing (1996): #101-106

Nightwing (1995): #2

Nightwing (1996): #0.5, 7, 14, 16-18, 19, 20, 24, 25, 37, 38-87, 88, 89, 100, 104, 109, 117, 153 (this isn’t EVERY issue Babs is in but all the important ones)

Batman Chronicles (1996): #9

Some of the best and most beautiful dickbabs moments come from birds of prey, and they give a great look into Babs’ side of things too! I recommend reading Bop and Nightwing alongside each other (If you can!) And I alos recommend you read some Batman arcs like Cataclysm, No Man’s Land and Bruce Wayne, Murderer? They show Dick and Babs working together and with the batfam. Fun Fact and slight spoiler for the ending of No Man’s Land, The ending scene where Dick and Helena randomly kiss was supposed to be between Dick and Babs, but someone messed up, and Rucka kinda just thought Dick was a horndog so no one fixed it 💔 there is still some good Dickbabs moments within that arc tho

Birds Of Prey (1999): #8, 19, 20, 23-61, 71, 76, 86

Robin (1993): #71

Gotham Knights: #17, 18, 26, 30, 32, 34, 35, 36, 42, 43

Harley Quinn (2000): #10-12

DC One Million (1998): #1 , 3

DC Universe Holiday Bash (1997): #2

Batman: Black Mirror (they aren’t together in this but it’s still important reading for their relationship imo and a fascinating/thrilling Dick!bats story with lots of Oracle besides)

Nightwing Annual 2 (for the conclusion of the proposal from Nightwing #117)

Li’l Gotham (2013): #1, 7, 10, 17

Convergence Nightwing/Oracle #1-2 (for the wedding. This is how pre-boot ended as far as I’m concerned)

New 52 Reboot:

Nightwing (2011): #4, Annual 1

Batgirl (2011): #3, 18, 21, 30, Annual 3, 45

Grayson (2014): #2, #12

REBIRTH:

Nightwing (2016) #1, 2, 3, 15, 44, 45, 46, 47, Annual 1

Batgirl (2016): #7, 10, 14, 15, 16, 17, 25

Dark Nights: Death Metal - the Last Stories of the DC Universe: #1

Batman (2016): #55

Batgirl (2016): #43, 50

Nightwing (2016): #50, 72, 73, 74, 75, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 102, 103, 104, 105, 106, 107, 108, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123 (ongoing)

Batman (2016): #100, 104, 118, 126, 127, 128, 137, 141, 145, 146, 148, 149,

Batgirls (2021): #7, 8, 10, 12

The Flash (2016): #787

Future State: Nightwing (2021): #1, 2

Future State: The Next Batman (2021): #4

Superman: Son of Kal-El (2021): #13

Saved by the Belle Reve (2022): #1

Tales of the Titans (2023): #1

Titans: Beast World (2023): #2, 3, 4, 6

Titans (2023): #6, 7

Batman / Santa Clause: Silent Knight (2023): #1-4

How to lose a Guy Gardener in 10 days (2024): #1

Super-Pets Special: Bitedentity Crisis (2024): #1

ELSEWORLDS / BLACK LABEL

Thrillkiller (1997): #1-3

Young Justice (2011): #22, 23, 25

Earth 2: World’s End (2014): #1, 3, 4, 6, 9, 10

Earth 2 (2012): #29

Batman: White Knight (2017): #1, 3, 4, 5, 6, 7, 8

Batman: White Knight: Batman Day (2018): #1

Batman: Curse of the White Knight (2019): #4

Batman: Beyond The White Knight (2022): #1, 4, 6, 7, 8

The Batman & Scooby-Doo Mysteries (2021): #4

Dc vs. Vampires (2021): #1, #2, #3, 4, 8, 12

Batman: The Long Halloween - The Last Halloween (2024): #1

Batman: Dark Age (2024): #4, 5, 6

The Boy Wonder (2024): #1

[mavcancees]

@silverstrying you ask, i reply

- how copyright works in code ( and minecraft ! )

to first determine how copyright works for code, we first have to determine whether the code is either a. a piece of code, or b. language coding

minecraft is written in java. java is a coding language. java, the code that builds the language for it to be usable, is copyrightable. matter of fact, there have been many instances of people appropriating java code and oracle ( the company that maintains java ) taking legal action. java is open source and of free access, which means that if you want to borrow code from the base language ( for example, if you wanted to make your own coding language ), you HAVE to make it also open source and free

minecraft code however, isn't exactly copyrightable, save a very specific exception

when you code to a program, you use pointers to put it simply. in the case of minecraft, what composes the game are called "classes", and if you want to change, say, how much damage a sword makes, you point to the sword class, and change the damage value

that is your code that you wrote. but it's not your code, you're pointing to a class that already exists that was written by someone else. and if someone else wants to change the damage a sword makes, they have to use the same class you did. so, your code is yours, but it's not unique, so it's not copyrightable. that is called "default code"

this applies to every single program and coding language ever ( that have a modifiable code ). you cannot claim for yourself something that anyone else will have to use if they want to do something similar or the same to what you did. such is the law ( the actual international law ! )

the singular only exception to this is the uniqueness clause. if you have written code based on someone else's language and program, that has made SIGNIFICANT changes to the base product, and that has enough self references ( meaning, you have created classes from scratch, and have pointers in your code that point to your own classes ) that someone copying must have taken your code because they couldn't simply figure it out, that is copyrightable as long as you have permission from the original program's developer. such is the case for big content mc mods ! if someone steals their code they are allowed to report it

it is worth noting that copyright in code is a big no no in the community. people like sharing and borrowing code because it makes for better more efficient code. people hate idea theft and code rippers, because it's disingenuous and 99% of the time done for profit. people hate lawsuits, they think they are corny. copyright is more of a social agreement thing, something cultural that everyone respects, and the actual legal instances are few and far between

so yes. code is free to use when it says free to use. minecraft is open source and regularly provides code efficiency updates for developers. and microsoft HATES people make legal threats about code copyright. minecraft code is free to use always and forever

[tokiro07]

Ichi the Witch ch.20 thoughts

[And the World Will Turn to Ichi]

(Topics: character analysis - Jikishirone/Ichi/Desscaras, narrative analysis - prophecy/speculation)

AwooGA!!!

God damn, that's a hell of a design Jikishirone's got! And her expressions are so fun, I'm such a sucker for that style of toothy grin, especially on girl characters

It's just such a shame that she's clearly only meant to be an occasional cameo at best if not a simple one-off at worst. Her design is just too busy to be a consistently recurring character, and being an oracle doesn't offer a lot of utility outside of being a plot device, as prophecies don't serve a story very well if they're being thrown around left and right

Not that she would do that, though. Jiki's clearly pretty fickle, only sharing an extremely important prophecy mere minutes before it came to pass so no one could do anything meaningful about it, so while she's not a Human Hater, she isn't necessarily a Human Lover either

Desscaras mentioned in ch.2 that there are Magiks that work alongside humanity, and clearly Jiki is one such Magik, but the fact that she's not going out of her way to make her prophecies as useful as possible suggests that she isn't actually interested in helping humanity. It may be that she's just looking to be entertained, or that since she knows the entire world is at stake, this is all just for self-preservation

Or she just has a nasty personality and she really is doing everything she can. She said she "received" her prophecies, suggesting that she doesn't have the power to look though the future on a whim. While she may be capable of withholding information, we don't have any proof yet that the 15-minute prophecy was available any earlier than that

Ooor it did exist earlier, buuut Jiki knew that if she shared the prophecy, Ichi wouldn't meet World Hater, and the dominos wouldn't fall the way they needed to afterward. Jiki may be playing 4D chess, and she knows exactly when a pawn needs to be where in order to set up a checkmate a thousand moves down the line

We simply don't know enough about Jikishirone's motivations or abilities to say how her personality informs her actions, but at the very least she's made it clear that she can't be relied on as a perfect preventative measure

Like I said, her prophecies are more of a plot device, giving us and the cast a sense of direction for where the story is meant to go next rather than serving as a comprehensive strategy guide

Time is Like a River

Now, I'm personally not a fan of prophecies that are so...blatant. "No Witch will ever acquire the World Hater Magik" is fine, because like Lord of the Rings' "no man can slay me," the original Japanese specifies that no "Magic Woman" will acquire the World Hater, leaving it open-ended that anyone who isn't a Magic Woman (like a Magic Man or a somehow non-Magic Woman) feasibly could

However, when the clause that "hope lies within the one who acquires the Uroro Magik" is introduced, that takes any and all ambiguity out of the equation: only one person can acquire a Magik at a time, so unless Ichi dies and another Madan comes along, the prophecy can only be referring to him

Vague prophecies give a lot of wiggle room and allow for narrative deception, giving the audience the opportunity to figure out for themselves what the author's true intentions are without it being spelled out for them. A specific prophecy like this becomes a question of "will it really happen or won't it" rather than "how will it happen." which I simply find less interesting

Of course, we've already established that Jiki can't really be trusted

As she's presented herself, she seems to be willing to hide information until the last minute, and even if her prophecies are perfectly accurate, they clearly don't inherently tell the whole story. As Jiki says, the part where "the Light goes out" was a recent addition to a previously existing prophecy, and one that already had an escape clause built-in with the Light existing at all to avert the destruction of the world. In other words, who's to say that Jiki doesn't already know the way to save Ichi that she just isn't sharing? Or that she won't find one down the line?

This uncertainty doesn't go unnoticed in-universe, either, as Ichi immediately agrees to throwing his life away for the sake of defeating the World Hater

Here For a Good Time, not a Long Time

Ever the optimist, Ichi looks at the prophecy as a win-win situation - either it's true and he dies doing what he loves (hunting and killing a strong opponent) or it's false and he gets to keep living to do what he loves. Either way, Ichi has always accepted the possibility of his own death during a hunt, so he takes the prophecy as more of a comfort that, even if he's fighting something strong enough to kill him, at least he'll take it down in the process

What's especially interesting though is that there's a little bit of a contradiction between this scene and when Ichi first killed the wolf in ch.1. Back then, Ichi thought there was no value in his life, and yet in order to survive, he found the strength of will to kill something else. This gives the impression that Ichi is the type who will do anything to survive, and yet here he's perfectly willing to die for the sake of the hunt, implying that he still doesn't value his life

This is probably something that will be touched on more next week, but I think it's less that he's willing to die and more that he's not bothered by death so long as he lives without regret. If he were to die of old age on a deathbed, I think he'd be pretty disappointed that he's not doing something fun with his last moments, but dying while taking down something stronger than him would be a hell of a story to tell in the afterlife (not that he believes in one)

The question isn't so much what Ichi thinks about death, though; the real question is if he's right to think that way about death, and it looks like Desscaras is going to be the one to answer that for us

It Should've Been Me

As Ichi emphatically agrees to Jikishirone's command that he heroically martyr himself, Desscaras can only stare in silence, her fist clenched in apprehension

There are a few ways to read into this. Since Desscaras was the one who was supposed to acquire Uroro, she may be upset that her failure means that someone else has to die fighting World Hater in her place. She may feel regret that she failed to acquire Uroro, she may feel responsible for getting Ichi killed, she might even feel jealous that she won't be the one to avenge her fallen home. It could even be a combination of all of them and any number of other emotions

It may also be that she's grown attached to Ichi and doesn't want to lose him. Seeing him be so glib with his life, especially since he's giving the same response that he gave when she invited him to join Mantinel in the first place, may well be heartbreaking for her, and again may make her feel like she's the one who got him killed. She may be reading into it the same way I am, surprised that he doesn't value himself as much as she expected

Whatever she's feeling though, her reaction next week will likely lead into a major thesis statement for the series - either she will say what Ichi needs to hear for him to understand just how valuable his life is, or Ichi will reveal a personal truth to Desscaras that makes it clear that while he does value his life, living it in a way that isn't true to himself isn't living at all

Basically, what it comes down to is whether or not Ichi is meant to have a positive character arc or a flat character arc. Is Ichi meant to learn a lesson, or is he meant to teach a lesson? The way this interaction goes will dictate the course of the narrative going forward, though certainly not immutably. It may turn out to be a misdirect, and whatever we're shown may end up reversed further down the line

Either way, I'm excited to see how Ichi and Desscaras' relationship develops from here. Desscaras having an actual emotional response to Ichi's attitude and fate already puts her on a different level than most shonen mentor figures, and I think that will only serve to make her vastly more interesting than the majority of her archetypical cohort

Until next time, let's enjoy life!

[faulty-heat-vents]

<What, no gifts for the lovebirds? Alright, if I can't give them fangs I'll have to trust you to make them into beasts at heart>

MEMO FROM COMMAND: ORACLE

The intrusion into the practices of my Academy- that you zealous Omninet dogs so often perform- is unwanted. My Pilots are mine alone to teach, and the fact that you question my ability to make them into effective weapons is evidence of either disrespect or incompetence.

If you’re so entrenched with the affairs of my Pilots, how about you elaborate on that “lovebirds” clause?

[inventors-fair]

CUSTOM CARD CREATION 101

Never submitted a card before? Let's take it from the top.

If you're on desktop, the gold standard of custom card creation is Magic Set Editor. It's a highly customizable program with versatile options for all sorts of card types.

If you're unable to download MSE, there are a number of free online card making programs. They're far less versatile, but they get the job done. You can find one that works best for you.

You can always ask for help in Discord if you don't have either of these options and would like a card rendered as an image by another inventor. Or, you can always submit as text if that works best for you!

If you're submitting as text, or if you just need a general checklist of things to have before you submit, make sure your card has ALL of the following:

Appropriate/final name

Properly formatted mana cost (if applicable)

Type(s)

Rarity (THIS ONE IS THE MOST OVERLOOKED)

Rules text—no typos, modern wording

Flavor text (if applicable/if there's space)

Power/toughness, if a creature

There are a number of options for ART as well. Art is one of the most recognizable part of any MTG card. Most of us are, assumedly, not professional illustrators. So:

MTG artist Winona Nelson made this fabulous post talking about art descriptions and art direction! You can add that to your post in lieu of actual art.

When adding art descriptions with images, it's easiest for formatting to add them directly to where the art would be. Here's an example:

Or! Do you want to draw your own art? Please do so! We strongly encourage everyone at any artistic skill level to submit with their own illustrations!

Just don't forget: if you're using any kind of visual, you need to have the art properly credited—and that includes yourself.

Otherwise... It's been common practice across the custom MTG community for a while to use fantasy art from across the internet. Pragmatically, as long as it's credited, there's no monetary harm as this is a non-commercial use of art. However, reposting in general isn't exactly kosher and isn't the best practice, and many card creators have tiptoed around that line. If you're able to get permission from outside art, please do so.

Regardless of your personal stances: submissions that use uncredited art will not be accepted. Even if it's fair use, even if it's a stock photo or game asset, even if it's your own art (and we'll remind you gently about that one, a lot of folks forget lol), all art must be credited.

Fair Use/Stock photos & illustrations: Most stock images have usernames of uploaders. Always look for the OP. This includes things like Wikimedia Commons as well.

Game Assets/art: When in doubt, credit the name & developer.

AI generated art is never allowed.

If there's a corner case not included on here, just send in an ask and we can answer it.

For rules text questions, You can use Scryfall to check oracle text for proper wording and other examples of weird wording effects if necessary. This includes keyword orders, if/when clause differences, and more. "Oracle text" is the most up-to-date wording for any given card. Need an example? Check out the card Necromancy.

Flavor text is the most esoteric and hard-to-pin-down aspect of any given card. As a rule of thumb, if you have the space to add it, you should strongly consider it. A strong twist can turn a decent card into a great card.

There are quite a few different kinds of flavor text:

Twists on common phrases/sayings that relate to the card, including puns

Quotes from the characters being depicted

Quotes from other characters in the world

Snippets of story before/during/after the action of the card

When writing flavor text, consider: What does that text add to the card that the mechanics, name, and/or art aren't already telling the player? Why does it matter?

N.B.—when adding quote attribution on MSE, use shift+enter to remove the line spacing before the emdash.

Last reminder: Please do not submit Universes Beyond cards and/or silver-border/acorn cards unless a contest specifically calls for it. Unless otherwise specified/implied, assume that all contests are looking for you to design cards for standard/premier play.

Most importantly, don't forget that we're expecting a lot of you from these cards, because you're doing all parts of the process—mechanics, editing, and presentation. Polish up as much as you can. You're wearing a lot of hats here, and it's hard work! But be proud of what you make, and embrace the challenge.

@abelzumi

[signalfog]

US Constitution - A Critique and Upgrade Options

SACCO & VANZETTI PRESENT:

THE CONSTITUTION IN FIRE AND CODE

A hard-nosed, ethical teardown of America's source code BASE SYSTEM: U.S. CONSTITUTION v1.0.1787

VANZETTI: The Constitution is not sacred. It’s a contract—one written by 55 elite white men, many of whom owned humans, and none of whom trusted the masses.

It’s a political OS designed to stabilize a fragile post-revolutionary elite consensus. It featured:

Separation of Powers: Isolation of functions to prevent autocracy, but also to slow democracy.

Checks and Balances: Not equilibrium—just distributed veto points.

Enumerated Powers: Core federal functions, tightly scoped.

Elastic Clause: An escape hatch for future relevance, designed to expand federal power slowly.

But its core failure? It was engineered for a low-bandwidth, low-population, literate-male landowning republic. It has not been significantly refactored since muskets and messengers. It is a creaking system straining under incompatible load.

SACCO: This wasn’t “for the people.” It was designed to keep the people contained. That was the function. The Senate was an elite kill switch. The Electoral College? A manual override in case democracy got uppity.

It’s not a broken system. It’s a functioning oligarchy framework with ceremonial democratic syntax.

BILL OF RIGHTS: PATCH OR PROP?

VANZETTI: The Bill of Rights was a retrofit—a patch to suppress anti-federalist rage. It formalized personal liberties but offered no systemic guarantees. It assumes good-faith actors will respect vague principles like “unreasonable” and “excessive.” No enforcement layer. No recursion. Just faith.

They are declarative rights. Not executable rights.

SACCO: You have the right to speak, sure. But no right to reach. You can protest, unless the city denies your permit. You can be tried by jury—if you can afford not to plead out.

These aren’t rights. They’re permissions granted by an extractive system when it suits the optics.

They tell you the government can’t search your house. They don’t tell you about digital surveillance dragnets, predictive policing, and facial recognition at protest marches.

The Bill of Rights is a beautiful lie in cursive. It reads clean. It runs dirty.

SYSTEMIC LIMITATIONS — 2025 REALITY

VANZETTI: The Constitution is brittle under modern load:

Elections: Electoral College and Senate distort democracy beyond recognition.

Legal System: Lifetime judicial appointments become ideological hard forks.

Rights Enforcement: Subjective interpretation, no auto-execution.

Transparency: Black-box governance remains default.

Corporations: Treated as persons with infinite speech budget.

Privacy: Undefined. Loophole the size of AWS.

Its failure modes are increasingly exploited by well-funded actors who’ve read the source code and know no one’s enforcing the terms.

SACCO: Don’t talk to me about founding wisdom when your “more perfect union” doesn’t define “truth,” doesn’t define “justice,” and doesn’t protect the poor from being data-mined, indebted, and incarcerated.

They wrote this to protect wealth from mobs. We’re the mobs now.

THE UPGRADE PATH: BLOCKCHAIN GOVERNANCE

VANZETTI: A new system must execute governance as code, not wishful interpretation. Here’s how it looks:

1. ConstitutionChain All laws, interpretations, amendments, and precedents recorded immutably. Transparent. Auditable. Every ruling is version-controlled. We no longer interpret the Constitution—we query it.

2. Smart Contract Rights Each civil liberty is codified. Violate it, and the system triggers penalties automatically. No discretion. No delay. Rights exist only if they execute.

3. ZK-ID Voting System Anonymous, verifiable, cryptographically secure civic identity. One citizen, one unforgeable vote. Gerrymandering becomes obsolete. Voter suppression becomes mathematically visible.

4. Distributed Judicial Logic No more black-robed oracles. Rulings handled by time-limited panels of legal professionals, selected randomly and transparently. All opinions stored, auditable, and revisable based on new precedent or revelation.

5. Public Key Legislative Tracking Every bill, every edit, every lobbyist fingerprint on public record. Representational corruption becomes a provable dataset.

SACCO: This isn’t utopian. It’s survival.

The current system runs on the belief that words written by slavers can protect the data rights of your daughter on a school Chromebook.

It can’t. You need a constitution that logs, executes, and cannot lie.

DEPLOYMENT STRATEGY

Phase 0: Parallel Chain Shadow legal and civic frameworks built at city and state levels. Use real elections as dry runs for blockchain voting. Publicly track existing corruption as a proof-of-need.

Phase 1: Digital Citizenship Opt-in constitutional layer for a new federated digital public. Users choose citizenship by protocol, not geography.

Phase 2: Critical Fork When the legacy system hits unsustainable entropy—financial collapse, legal legitimacy crisis, climate-triggered authoritarianism—the constitutional fork becomes the continuity government.

SACCO: When the Republic dies, it won’t announce it. It will just stop executing your rights and blame you for noticing.

We’re not trying to fix the system.

We’re building a better one in its shadow.

CONCLUSION:

VANZETTI: The Constitution was a brilliant v1.0. But it cannot scale, cannot adapt, and cannot protect. It needs to be replaced by something that runs honestly in real time.

SACCO: It’s not about preserving liberty. It’s about enforcing it.

If your freedom isn’t programmable, it’s marketing.

“In the beginning, they wrote it in ink. Now we write it in code.”

[digitaldetoxworld]

Structured Query Language (SQL): A Comprehensive Guide

 Structured Query Language, popularly called SQL (reported "ess-que-ell" or sometimes "sequel"), is the same old language used for managing and manipulating relational databases. Developed in the early 1970s by using IBM researchers Donald D. Chamberlin and Raymond F. Boyce, SQL has when you consider that end up the dominant language for database structures round the world.

Structured query language commands with examples

Today, certainly every important relational database control system (RDBMS)—such as MySQL, PostgreSQL, Oracle, SQL Server, and SQLite—uses SQL as its core question language.

What is SQL?

SQL is a website-specific language used to:

Retrieve facts from a database.

Insert, replace, and delete statistics.

Create and modify database structures (tables, indexes, perspectives).

Manage get entry to permissions and security.

Perform data analytics and reporting.

In easy phrases, SQL permits customers to speak with databases to shop and retrieve structured information.

Key Characteristics of SQL

Declarative Language: SQL focuses on what to do, now not the way to do it. For instance, whilst you write SELECT * FROM users, you don’t need to inform SQL the way to fetch the facts—it figures that out.

Standardized: SQL has been standardized through agencies like ANSI and ISO, with maximum database structures enforcing the core language and including their very own extensions.

Relational Model-Based: SQL is designed to work with tables (also called members of the family) in which records is organized in rows and columns.

Core Components of SQL

SQL may be damaged down into numerous predominant categories of instructions, each with unique functions.

1. Data Definition Language (DDL)

DDL commands are used to outline or modify the shape of database gadgets like tables, schemas, indexes, and so forth.

Common DDL commands:

CREATE: To create a brand new table or database.

ALTER:     To modify an present table (add or put off columns).

DROP: To delete a table or database.

TRUNCATE: To delete all rows from a table but preserve its shape.

Example:

sq.

Copy

Edit

CREATE TABLE personnel (

  id INT PRIMARY KEY,

  call VARCHAR(one hundred),

  income DECIMAL(10,2)

);

2. Data Manipulation Language (DML)

DML commands are used for statistics operations which include inserting, updating, or deleting information.

Common DML commands:

SELECT: Retrieve data from one or more tables.

INSERT: Add new records.

UPDATE: Modify existing statistics.

DELETE: Remove information.

Example:

square

Copy

Edit

INSERT INTO employees (id, name, earnings)

VALUES (1, 'Alice Johnson', 75000.00);

three. Data Query Language (DQL)

Some specialists separate SELECT from DML and treat it as its very own category: DQL.

Example:

square

Copy

Edit

SELECT name, income FROM personnel WHERE profits > 60000;

This command retrieves names and salaries of employees earning more than 60,000.

4. Data Control Language (DCL)

DCL instructions cope with permissions and access manage.

Common DCL instructions:

GRANT: Give get right of entry to to users.

REVOKE: Remove access.

Example:

square

Copy

Edit

GRANT SELECT, INSERT ON personnel TO john_doe;

five. Transaction Control Language (TCL)

TCL commands manage transactions to ensure data integrity.

Common TCL instructions:

BEGIN: Start a transaction.

COMMIT: Save changes.

ROLLBACK: Undo changes.

SAVEPOINT: Set a savepoint inside a transaction.

Example:

square

Copy

Edit

BEGIN;

UPDATE personnel SET earnings = income * 1.10;

COMMIT;

SQL Clauses and Syntax Elements

WHERE: Filters rows.

ORDER BY: Sorts effects.

GROUP BY: Groups rows sharing a assets.

HAVING: Filters companies.

JOIN: Combines rows from  or greater tables.

Example with JOIN:

square

Copy

Edit

SELECT personnel.Name, departments.Name

FROM personnel

JOIN departments ON personnel.Dept_id = departments.Identity;

Types of Joins in SQL

INNER JOIN: Returns statistics with matching values in each tables.

LEFT JOIN: Returns all statistics from the left table, and matched statistics from the right.

RIGHT JOIN: Opposite of LEFT JOIN.

FULL JOIN: Returns all records while there is a in shape in either desk.

SELF JOIN: Joins a table to itself.

Subqueries and Nested Queries

A subquery is a query inside any other query.

Example:

sq.

Copy

Edit

SELECT name FROM employees

WHERE earnings > (SELECT AVG(earnings) FROM personnel);

This reveals employees who earn above common earnings.

Functions in SQL

SQL includes built-in features for acting calculations and formatting:

Aggregate Functions: SUM(), AVG(), COUNT(), MAX(), MIN()

String Functions: UPPER(), LOWER(), CONCAT()

Date Functions: NOW(), CURDATE(), DATEADD()

Conversion Functions: CAST(), CONVERT()

Indexes in SQL

An index is used to hurry up searches.

Example:

sq.

Copy

Edit

CREATE INDEX idx_name ON employees(call);

Indexes help improve the performance of queries concerning massive information.

Views in SQL

A view is a digital desk created through a question.

Example:

square

Copy

Edit

CREATE VIEW high_earners AS

SELECT call, salary FROM employees WHERE earnings > 80000;

Views are beneficial for:

Security (disguise positive columns)

Simplifying complex queries

Reusability

Normalization in SQL

Normalization is the system of organizing facts to reduce redundancy. It entails breaking a database into multiple related tables and defining overseas keys to link them.

1NF: No repeating groups.

2NF: No partial dependency.

3NF: No transitive dependency.

SQL in Real-World Applications

Web Development: Most web apps use SQL to manipulate customers, periods, orders, and content.

Data Analysis: SQL is extensively used in information analytics systems like Power BI, Tableau, and even Excel (thru Power Query).

Finance and Banking: SQL handles transaction logs, audit trails, and reporting systems.

Healthcare: Managing patient statistics, remedy records, and billing.

Retail: Inventory systems, sales analysis, and consumer statistics.

Government and Research: For storing and querying massive datasets.

Popular SQL Database Systems

MySQL: Open-supply and extensively used in internet apps.

PostgreSQL: Advanced capabilities and standards compliance.

Oracle DB: Commercial, especially scalable, agency-degree.

SQL Server: Microsoft’s relational database.

SQLite: Lightweight, file-based database used in cellular and desktop apps.

Limitations of SQL

SQL can be verbose and complicated for positive operations.

Not perfect for unstructured information (NoSQL databases like MongoDB are better acceptable).

Vendor-unique extensions can reduce portability.

Java Programming Language Tutorial

Dot Net Programming Language

C ++ Online Compliers 

C Language Compliers 

[tuiliel]

Hello, the anon seeking fae advice is back once more. Please know there is absolutely no rush and I completely understand life being its own string of whimsy. Truly, thank you for your help. It is sincerely appreciated.

I was specifically considering a brownie due to a string of events. To begin, my patron is quite the trickster. He prefers a lawless game of chess rather than anything cut-and-dry. I had gotten into researching the fae out of curiosity born from thin air whilst cleaning out a cluttered old room, with intentions of doing my practice there. I left off my readings on an article about brownies and, since then, have proceeded to lose my keys thrice, several other items have vanished and reappeared in locations I swore they were not left, and I could not say if I haven't lost more. I am typically good at remembering where I placed my items, but it felt as though my memory was stolen from me. My spur was drawing an Oracle Card that questioned if I felt the presence of otherworldly helpers.

Thus how I arrived here. I typically draw Tarot and Lenormand Cards at my altar or offer prayers to a lit candle before drawing from an Oracle Deck. I'm willing to experiment with other means if it could be beneficial with communicating with them. (With a few practice tests beforehand, of course.)

In a contract, would you say to specify working times? Such as days or the week or hours. Or could that be a poor choice? As well, do you think it would be better to offer daily offerings or offer them weekly? (I shall not forget to add in a clause for missed offerings.) I imagine if this is a trial period, we both can negotiate terms as time goes along and if it takes root. Although, I fear this could be interpreted as disrespectful.

Then yes, I would skip the cheese and try for a Brownie. Though I imagine your patron might have someone in mind already to send your way; Manannán Mac Lir has sent a few my way after catching my attention in a similar fashion - a string of "loud" synchronicities.

Cartomancy is perfectly reasonable - I just usually caution against something like a pendulum with only yes/no/maybe type answers, particularly for a neophyte, because the phrasing of the question will matter so much that a no might actually be an implied yes. Cartomancy gives you more nuance, particularly if you draw at least three cards.

I would not specify working times. In fact, though I suggest weekly offerings, I would suggest you phrase it "at least four times a month". The more flexibility you can give yourself at the beginning, the easier it will be to continue to fulfill the contract in times of distress. Because fairy contracts are not to be taken lightly: breaking a contract - even with a being you have come to consider a close friend - can have dire consequences. Morgan Daimler tells a story of how they came close to breaking one once, with beings they consider to be family, and went blind for several days as a warning.

(Speaking of which, if you haven't read any of Daimler's books, I suggest you do - the Kindle editions are fairly cheap.)

And yes you can absolutely continue to negotiate during the trial period, and even after, so long as you negotiate before you change something, not after, and you leave space in the conversation for your new companion to say no, or counter propose, explaining their own needs and desires. The only time it is disrespectful to attempt to renegotiate is when you are on the brink of breaking the agreement, or have already done so.

[icharchivist]

like i said. if you wanna suffer ill be happy to watch. but also the only thing i know about ff 15 is that one max0r video which while very funny is probably not 100% accurate to the story

now this is giving me too much power. I'll be happy (and sad) to oblige. And give you a quick overview.

and yeah i doubt that one video is a good description of it. so.

cracks fingers.

One of us is going to end up crying by the end of this. it's going to be me. but you're welcome to join me.

Final Fantasy 15 is the story of Noctis Lucis Caelum, crown prince of the kingdom of Lucis.

The Kingdom of Lucis is facing a crisis as the ever-growing Niflheim Empire is trying to expend and take the kingdom over, at the same time as a sickness called Starscrouge is slowly killing people. When the night falls, daemons come in the dark, and ever since those events have started happening, nights are growing longer in longer.

As the Empire of Niflheim is discussing peace treaty with the Kingdom, a clause is made on their contract to have Noctis marry Princess Lunafreya Nox Fleuret, who's been held captive by Niflheim for about a decade, and who has been Noctis's childhood friend and penpal. She is the Oracle, chosen by a prophecy to be the only person capable of healing the Starscrouge before the sickness takes hold.

King Regis decides to send his son to his marriage-to-be right before the peace treaty is officially signed, accompanied by his three most trusted friends - Ignis Scientia, who's been working as a royal advisor, cook, caretaker ever since they were children, Gladiolus Amicitia, who's been Noctis' bodyguard and royal trainer for a very long time, and Prompto Argentum, Noctis' school bestie who, despite having no relation to the royal family, is the only person outside of it Noctis managed to get close with.

But soon after their departure, the peace ceremony goes array- King Regis is murdered and the Kingdom of Lucis fall to the Empire, now leading a manhunt for Noctis to kill the royal lineage, and recover the Ring of Lucis, a powerful artefact carried through the family that, especially once coupled with the Magic Crystal that is the source of all magic in Lucis, can connect its wielder with the Kings of Old to access tremendous power left by the Gods.

See, there is a prophecy in the Lucis lineage that one day the One True King Of Light, chosen by the Gods, will be able to purge the world of the Starscrouge and Daemons, ending this curse at all cost. and, as you can imagine, this burden will fall on Noctis's shoulders as he goes through his new journey to awake the old gods and reunites the soul weapons of the previous Kings in order to unlock the full potential of his power.

The game mostly plays as an open world where you explore the valley with your besties. There is a lot that is very difficult to communicate that is just about how it feels like a camping simulator. You don't want to stay up at night for too long because Daemons are overleveled and bitch to kill, so you try to level up, do your missions, and enjoy your time connecting with your friends, learning more about them.

From Prompto's insecurities about his place in this journey, to Ignis's unwavering loyalty that would oversee Noctis's protection to the end, to Gladio devoting himself to being the shield even when everything starts to fall apart, you end up caring a lot for this group of misfits who are just trying to enjoy their journey knowing it might be their last.

You spend the game mostly having fun with them. Finding place to camp, new recipes for Ignis to cook, Prompto is constantly taking pictures and selfies to remember the journey by, you stop to every ponds to be sure Noctis can enjoy all of the fishing he can, you meet up with Gladio's little sister, it's really a really heartful game in ways that are very difficult to articulate.

... until shit hit the fan.

You're introduced to the real antagonist of the game, the Empire's chancelor, Ardyn Izunia, who's been pulling the strings all along, while also helping Noctis unlock the powers of the Gods.

And when finally it's time for you to go find Lunafreya for their wedding and hopefully linking the power of the Oracle to the King of Light in order to finally purge it all.....

Ardyn will brutally murder Lunafreya in front of Noctis, killing with her any possibility to stop the Starscrouge and the endless nights around the corner. The death itself is pretty heartbreaking, showcasing Noctis' very difficult time to deal with her loss, and Luna was defined by how she was willing to do everything to carry her duty to the end, so it was really sad.. but Luna was not very well written unfortunately (she appears maybe 15mins in the whole game up until this point) so i don't have as much to say about it :( it was super heartbreaking but yeah... yeah.

During this confrontation, Ignis will lose his eyes trying to protect Noctis, as Noctis was unconscious and Ignis grabbed the Ring of Lucis to ask for the powers of the Gods to protect him, and the Gods burn his eyes off. (it's so hard to properly explain but Ignis becoming blind ends up developping a lot of problems in the plot, of course, but especially in the gameplay. Like you spend the game having Ignis cook all sort of things and exitedly tell you about what he's going to cook today, and then your first campire after this incident you see the only food you can cook is some canned bean and it's just. so sudden in the way to tell you Ignis is changed for ever by it.)

Shortly afterward, Ardyn will create illusions that will push Noctis to push Prompto off from a moving train, resulting in Prompto getting kidnapped and experimented on by the Empire.

all while Gladio is losing his faith in Noctis because everyone is expecting so much from him, that they're their only hope, and yet Noctis is so lost in his grief that he doesn't focus on the bigger picture, while everyone he loves is losing everything around them.

When you finally decide to take down the Empire's HQ to get Prompto's back, is when a lot of truth starts to unravel.

You learn that Prompto is the clone of one of the highest funding members of the Empire, who was created to become one of the mindless drone enemies you fight the whole game, but has been smuggled out of the labs before he could be turned as such - only keeping a mark on his wrist reminding him of who he truly is. As much as Prompto always wanted to be Noctis' friend, he always feared that him being a clone, a failed weapon made by the enemies, would eventually disgust Noctis, and he feared all his life that Noctis would turn against him. so you can imagine the panic for Prompto when Noctis did attack him due to the illusions.

Most importantly though, you learn that Ardyn Izunia is actually Ardyn Lucis Caelum - one of the prince of Olds, the first person who was prophetized to be the King of Light. Bahamut himself, god of gods, gave him for missions to purge the Starscrouge, and Ardyn did just that, and took all of the Starscrouge in the world inside of his body, eradicating it from this world... and when he came to ask what he was supposed to do now, the Gods turned on him and left him to his fate, as he was not the one to actually serve to finish this prophecy. (if i recall correctly they legit say it wouldn't be narratively satisfying. Fuck the Gods, fuck Bahamut, all the homies hate Bahamut no matter the universe.)

Then, as the gods refused to clean him from the scrouge, his brothe, Somnus, tried to kill him before locking him into a magical prison and a magical slumber for the centuries that followed. Somnus became known as the Savior of Lucis, he took the credit for the actions of his brother, and build his kingdom on his ashes, continuing his royal line until Noctis' birth out of it.

When the Niflheim Empire started to come to power, they freed Ardyn, and figured out how to be able to use his power -- Ardyn could unlean the Starscrouge inside of him and have it spread into the world.... and we learn that people who "die" from the Starscrouge actually become Daemons, creature of the night, and the more people become Daemons, the longer the night will last.

And so Ardyn unleashed all of his power, all of his suffering, but himself has been turned into a Daemon at this point due to the sickness ravaging his body for centuries. He only feels pain, and he cannot die, for the sickness made him immortal. So while the Empire woke him up to use him, Ardyn decided instead to use the Empire to take revenge on the descendant of his brother, destroy the world he had sworn to save, and finally by the end, being killed by the True King of Light in the way the Gods will find narratively satisfying.

And finally, as our four companions are trying to escape the forteress, Noctis finds the Crystal, and with all the power he has gathered since then, and prompted by Ardyn telling him that the only way for him to know how to defeat him, Noctis approached it... and was taken in by the Crystal.

In there he met the Kings of Old who told him about the prophecy. The King of Light will pure the world of the Starscrouge and the Demons by taking out Ardyn for good.... but since Ardyn cannot die, his soul will always come back into his body, the King of Light must die as well in order to kill Ardyn's soul in the afterlife once its there.

Noctis therefore learns that by the end of his journey, the only thing that awaits is his own suicide in order to finally put Ardyn to rest.

The Crystal kept Noctis in it for about ten years. For ten years Noctis could do nothing but wait, as the Night fully took the lands over and destroyed everything. Only small camps here and there managed to survive and fight -- and his three friends have been trying to do their best for the people's survival, while being torn apart at the sudden loss of Noctis that day.

When Noctis finally returns, he can meet with his friends one last time. And tell them what awaits him.

For one last time you team up with your dearest friends, all of them having to be aware that they're walking you out so you can kill yourself to finally bring peace.

Before entering the final room to the final boss fight, Noctis turns to his friends, and ask Prompto to give him one of the pictures he took. You go through all the pictures you took as Prompto as you decide which picture Noctis will hold on in his last moments, holding on knowing they were the people who brought him on this journey to start with. In there Noctis will share his final words with them.

And finally you leave your friends behind. Finally it's time to fight Ardyn as he himself only awaits for death. Two dead men giving each other a last fight, two pawns by the prophecy made by the Gods, tool in a narrative that never saw them as humans, no matter how hard they clang to their humanity and to the people they loved.

One last final fight, finally killing Ardyn. And watching Noctis climbs on the throne of his father, and empale himself with all of the swords of the previous kings, in order to finish this fight in the afterlife.

And so the game ends. Ardyn is dead. The Starscrouge and Daemons are purged from this world. the Kingdom of Lucis can live on and see better days. And Noctis is dead as well, standing on the throne of his father.

In the last moments of the game you see him in the afterlife where he reunited with Lunafreya. He's holding the picture you picked in the previous scene. Looking over his friends one last time.

And then in case it's not enough you have the DLCs. Ardyn's DLC tell you more about how the Gods set them up for narrative satisfaction to start with. Then you have all three friends' DLC, set at points in game when you don't know what happened to them. But all of them ends with some final goodbye of some sort.

Gladio's DLC is the most underwhelming one in general so i don't really know what to say about it, and it doesn't really have a big payoff.

Prompto's show how he felt, abandonned in the snow when Noctis almost killed him. Having to wrestle with his existence as a clone, and figuring out if Noctis even wants him by his side. This DLC ends on a last conversation between Prompto and Noctis right before Noctis entered the crystal, in which Noctis tells Prompto he hopes he'll be by his side as he'll try to be a good king. Prompto promise he will be, always.

And then. Ignis' DLC. god that fucking DLC.

You really see the events in which Ignis stole the Ring to try to protect Noctis there, the event that rendered him blind. You see how much he fights out of devotion for Noctis. And you learn that when he put the ring on, the Kings of Old told him Noctis was going to die. Ignis spent his life protecting Noctis. In fact, you go through various flashback of their first meeting. Ignis has to learn that the kid he's protected his whole life, is going to die, and there's nothing he can do about it, because this is the fate that has been drawn on him.

On the first ending of the DLC, There is one last goodbye. Where Ignis wants to follow Noctis to the end and Noctis has to stop him, telling him that he wants him to live on.

(so that's the scene where i was crying so hard i ended up tripping in the stairs)

BUT THEN Ignis's DLC has an alternative ending. an ending where when Ignis hears the plans the Gods had planned for Noctis, he tells them, screw you. I'm never going to let it happen to him. I'll fight all of you if i have to and i'll save Noctis from this cruel fate you have planned.

And so in this ending, Ignis doesn't let Noctis walk into the Crystal and they work together, in an alternative way, until they can save him and put him on the throne.

and let me be clear: this ending is impossible by the game's lore. It's purely a fanservice fix-it ending, a what if, Ignis' ultimate proof of love that is enough to screw over the prophecy hundred of years in the making.

Where Ignis manages to save Noctis so Noctis can actually live on as the King he was raised to be. For ever at his side.

SO. WELL. WELL. I NEVER RECOVERED.

(and i am in fact crying as i'm writing all of this)

all of that while the main theme of the game is a Stand By Me cover by Florence + The Machine that will forever rip your heart and will leave you crying your eyes out as you finish this game, especially after the true ending, watching Noctis' die, and then hearing this fucking damn song.

Anyway i never fucking recovered from it. Like, never.

Like, even a summary doesn't do it justice. My first playthrough took me hundreds of hours. I spent hundred of hours with those kids. Enjoying their banters, seeing them protect each other, fight with one another. There's so much of their dynamic that is so deep into the gameplay, the way your companions will check on you during a fight, the moments they'll pause to have a high five, those moments of pure happiness where you know they're having fun by each other's side.

and Noctis being such a good character you really get to love and for what. And for what!!!!!!!! to get him killed by the end???? like for crying out loud. literally.

So yeah that's the speedrun of what FF15 is about. It's about tearing my heart out of my chest, that's what it is. (and others themes but you get my point)

Anyway. Yeah. Here you are. Here you know FF15's story.

and btw there was a little webseries set right before the event of the games, telling you how each of those friendships started. if you ever goot curious through reading all of this, i definitely recommend it. (the playlist is from newest to oldest though so be sure to watch on the right order)

was it worth it.

[findswoman]

Writer 20 Questions

Tagged by @jedi-valjean. Thanks so much!

1. How many works do you have on AO3?

Currently 115.

2. What’s your total AO3 word count?

363,324.

3. What fandoms do you write for?

For the most part just Star Wars (various flavors thereof), but I have a very few Tolkien things too.

4. What are your top five fics by kudos?

Cards against Monotony; or, The Best Rainy Lothal Day Ever (47)

Sixth Time’s the Charm (40)

Beautiful, Inexactly (32)

The Song, the Sea, and the Mand’alor (29)

“I saw the wolf…” (28)

5. Do you respond to comments? Why or why not?

Of course! I want to let my commenters know how appreciated they are! And it’s fun to meet new readers and writers.

6. What’s the fic you wrote with the angstiest ending?

I have a good number of stories with angsty endings, but the angstiest to date may be Opus Sixty-Six, in which two OC non-Human musicians captured by the Empire are forced to perform for the Emperor but resist by playing a different piece of music from what he ordered, based on what happens to the two performers at the end (not going to spoil it).

7. What’s the fic you wrote with the happiest ending?

I have a good number of stories with happy endings, too! A lot of them involve OCs, but one that involves an happy ending for an EC following from particularly angsty source material is The Rains of Scarif, in which #JynErsoLives.

8. Do you get hate on your fic?

Thankfully this has never happened to me, at least not to my knowledge.

9. Do you write smut?

Nooo. I gave it a very, very tentative try a long time ago, but it was a complete and utter no-go.

10. Do you write crossovers?

I haven’t yet, but maybe sometime I’ll try!

11. Have you ever had a fic stolen?

No, at least not to my knowledge.

12. Have you ever had a fic translated?

Yes! Between the Porch and the Altar was translated into French by Yahiko: Entre le portique et l’autel. It was a prize that he offered for TheForce.net Fanfic’s Fanfic Awards one year, and it’s definitely one of the most unique ways I’ve ever had a fic recognized!

13. Have you ever co-written a fic?

Just a few times, and the results are posted on the TheForce.net forums rather than AO3: Cupcakes for a Cupcake (with Ewok Poet) and Dinner at the Hungry Hutt (with Chyntuck). But I also had aikisenshi (TheRynJedi) contribute part of chapter 22 of Shaman, Traveler, Oracle.

14. What‘s your all-time favorite ship?

I am of course partial to those that involve OCs of mine, but in terms of established characters, perhaps Kanera, and perhaps the Frog Lady and Frog Gent? I don’t tend to think in terms of ships most of the time, though (but have nothing against those who do).

15. What’s the WIP you want to finish but doubt you ever will?

I used to say this about The Book of Gand, but it may not actually be in that category anymore! Actually, currently nothing is in that category for me right now, but that could certainly change.

16. What are your writing strengths?

Setting descriptions! OC creation! Whimsical humor! Economy of expression! Worldbuilding! Anything involving alien cultures/traditions/ceremonial/etc.!

17. What are your writing weaknesses?

Action and battle scenes! Political intrigue! Characters double- and triple-crossing each other! Overly long sentences with too many clauses! Too many em dashes! Too many sentences/clauses that begin with “and” or “then”! (Linking sentences/thoughts together in general!)

18. Thoughts on writing dialogue in another language for a fic?

In terms of in-universe languages, when this happens within my stories I try to signal it in some other way. In terms of real-life languages: oof, I don’t know if I’m the right woman for that job, but I have immense respect people who are able to write stories in languages other than their mother tongue.

19. First fandom you wrote for?

Star Wars. One sticks with what works, I guess!

20. Favorite fic you’ve ever written?

Ah, I hate this question so much. 😁 I love them all, don’t you know! But I would say that I have a very specific soft spot for the 20K+ fics I’ve somehow managed to write: The Book of Gand and Shaman, Traveler, Oracle, just because I’m so proud of myself for managing to get through them (or, in the case of BOG, the component stories thereof, all of which are in excess of 15K words and three out of four of which are in excess of 20K).

Tagging:

Anyone I know (or don’t know) who is a writer who happens to see this. 🙂

[kumarom]

SQL ORDER BY LIMIT

We can retrieve limited rows from the database. I can be used in pagination where are forced to show only limited records like 10, 50, 100 etc.

LIMIT CLAUSE FOR ORACLE SQL:

If you want to use LIMIT clause with SQL, you have to use ROWNUM queries because it is used after result are selected.

You should use the following code:

[banarjeenikita]

How to Use Oracle Cloud ERP SQL Notebook for Inventory Management Reporting

Efficient inventory management is crucial for any organization that handles stock or assets. Oracle Cloud ERP provides a robust platform for businesses to manage and streamline their inventory operations. One of the most powerful tools within this suite is the Oracle Cloud ERP SQL Notebook, which allows users to create customized reports, analyze inventory data, and make informed decisions in real-time.

In this article, we’ll explore how to use Oracle Cloud ERP SQL Notebook for inventory management reporting, helping you optimize your stock levels, track key metrics, and enhance overall operational efficiency.

1. Understanding Oracle Cloud ERP SQL Notebook

The Oracle Cloud ERP SQL Notebook is a tool that enables users to run SQL queries directly against the data stored in the Oracle Cloud ERP system. This feature provides flexibility for users who need to extract specific insights from their data, going beyond the predefined reports offered by the ERP system.

SQL Notebook allows users to write, execute, and save SQL queries, creating customized reports that meet unique business needs. For inventory management, this is particularly useful, as different organizations may have varying metrics, KPIs, and reporting requirements.

2. Setting Up Oracle Cloud ERP SQL Notebook for Inventory Reporting

Before you can start using Oracle Cloud ERP SQL Notebook for inventory management reporting, it’s important to ensure that you have the appropriate access and permissions to interact with the inventory data.

Steps to get started:

Access Permissions: Ensure you have the necessary user privileges to access inventory data within the Oracle Cloud ERP system. This includes the ability to execute SQL queries and view inventory-related tables.

Understand the Data Schema: Familiarize yourself with the inventory-related tables and fields within the Oracle ERP database. These could include tables for stock levels, purchase orders, shipment data, and more. Knowing the structure of your data will help you write more accurate and efficient SQL queries.

SQL Knowledge: Basic knowledge of SQL (Structured Query Language) is required to create meaningful queries. You will need to understand SELECT statements, JOIN operations, WHERE clauses, and aggregation functions like COUNT, SUM, and AVG.

3. Writing SQL Queries for Inventory Management

With Oracle Cloud ERP SQL Notebook, you can create custom SQL queries to generate various types of inventory management reports. Below are a few common reporting needs and example queries to get you started.

4. Generating Real-Time Reports

One of the major advantages of using Oracle Cloud ERP SQL Notebook is the ability to generate real-time reports. Unlike traditional static reports, SQL Notebook allows you to refresh the data and instantly get the latest inventory metrics. This feature is particularly useful for businesses with dynamic inventory environments where stock levels and orders change frequently.

To generate real-time reports, you can schedule queries or run them on-demand directly in the SQL Notebook. The output can be exported to various formats (e.g., Excel, PDF) or integrated with other reporting tools for further analysis and presentation.

5. Optimizing Inventory with Insights

By using Oracle Cloud ERP SQL Notebook for inventory management, you gain deep insights into your stock levels, sales trends, and operational inefficiencies. These insights can be used to optimize your reorder processes, prevent stockouts, and improve overall supply chain management. Over time, the data-driven approach provided by SQL queries will help reduce excess inventory, save costs, and enhance customer satisfaction.

Conclusion

Oracle Cloud ERP SQL Notebook is a powerful tool that provides unparalleled flexibility in generating custom inventory management reports. By leveraging SQL queries, businesses can gain real-time insights into their stock levels, sales performance, and turnover rates. With the ability to create tailored reports, Oracle Cloud ERP SQL Notebook enables organizations to make data-driven decisions that optimize inventory management and improve operational efficiency.

[tasmiyakrish]

Essential Data Science Cheat Sheets for Quick Reference

As a data scientist, having quick access to helpful cheat sheets can be invaluable. Cheat sheets provide concise summaries of key concepts, formulas, code snippets, and more - allowing you to refresh your memory or find information quickly without having to dig through lengthy reference materials.

If you want to advance your career at the Data Science Training in Pune, you need to take a systematic approach and join up for a course that best suits your interests and will greatly expand your learning path.

In this post, we've compiled some of the most essential data science cheat sheets that can serve as handy references for data professionals at all levels.

Python for Data Science Cheat Sheet

This comprehensive cheat sheet from DataCamp covers a wide range of Python essentials for data science, including:

Pandas data structures and functions

Matplotlib visualization tips

NumPy arrays and functions

Scikit-learn machine learning algorithms

And more

The cheat sheet is available in both one-page and two-page versions, making it easy to print out and keep nearby.

SQL Cheat Sheet

Mastering SQL is a crucial skill for many data roles. This SQL cheat sheet from KDnuggets provides a handy reference for common SQL statements, clauses, functions, and data types. It also includes syntax examples for popular SQL dialects like MySQL, PostgreSQL, and Oracle.

Probability and Statistics Cheat Sheet

Data science heavily relies on probability and statistics concepts. This cheat sheet from Stanford covers key formulas, distributions, and statistical tests that data scientists should know, like:

Bayes' Theorem

Central Limit Theorem

Confidence intervals

Hypothesis testing

Machine Learning Algorithms Cheat Sheet

Understanding the different machine learning algorithms and when to apply them is critical. This machine learning cheat sheet from Stanford ML Group summarizes the characteristics, use cases, and pros/cons of popular ML algorithms like linear regression, decision trees, k-nearest neighbors, and more.

For those looking to excel in Data Science, Data Science Online Training is highly suggested. Look for classes that align with your preferred programming language and learning approach.

Data Cleaning Cheat Sheet

Data cleaning and preparation is a major part of any data scientist's work. This data cleaning cheat sheet from Springboard covers common data cleaning techniques and best practices, including handling missing values, removing duplicates, handling outliers, and transforming data.

Tableau Cheat Sheet

For data visualization practitioners, this Tableau cheat sheet from The Data School provides a handy reference for Tableau functions, chart types, keyboard shortcuts, and other useful tips.

Having these essential data science cheat sheets on hand can help you work more efficiently, refresh your knowledge quickly, and become a more well-rounded data professional. Bookmark them, print them out, or keep them easily accessible as you tackle your next data science project.

[casualdestinycandy]

April 24, 2024

Hello, a lot done today too! Making lots of progress recently in my course. Maybe be done with it soon! Looking forward to it!

Topics Covered:

Using the WITH CHECK OPTION Clause in SQL

Using the WITH READ ONLY Clause on Views

Dropping Views

What are Data Dictionary Views in Oracle?

The Dictionary View

Difference Between USER, ALL, DBA and V$ Prefixes

USER_OBJECTS, ALL_OBJECT and DBA_OBJECTS Views

Total Time: 4 Hours

Life:

Recently been into reading and watching camping videos! They're so much fun. I may not get much done tomorrow I have an appointment to go to but I hope I get enough done so that I'm almost done with this new section I started today. I also started reading cozy mysteries which I love a lot. I'm glad I got introduced to these.

I never owned an e-reader before but I really like what Kobo recently came up with! Two colored e-readers sound like a great option for someone (me) who doesn't own one yet. I'm wondering which one I should save for...The Kobo Libra color with the buttons or the basic clara. Who knows I think I'll be happy either way though.

Have a great day everyone!

[polyhedralmice]

I just signed up for the Shit or Get Off the Pot game jam on itch.io that challenges participants to design and publish 10 1-page solo ttrpgs in the month of May. I’ve already got a list of random ideas going for when the jam starts on May 1st. The (growing at an alarming rate) list includes:

- playing as the Angel AND the Devil on someone’s shoulder

- Mapmaking?

- Yahtzee style dice pool

- Playing cards/tarot cards

- A non d6 or d20 game

- Weird west?

- Travel based

- Field journal

- Radio/radio station themed? Cassettes? Mixtapes? (Use Spotify playlist? Supply Spotify playlist?)

- All the oracles

- Fate hack

- Superhero insurance agent

- Build a drum solo/guitar solo

- Dice stacking mechanic (d6s) (dice pool, when you fail you lose the die from the pool when it gets stacked. A game of inevitable failure.

- Build a Frankenstein-y monster

- Word association

- Choose your own adventure/flow chart

- Alexa keeps getting weirder (misinterpreting requests etc) Eldritch Alexa (Cthulhu?)

- Something that involves coloring shit in

- Word bank- connect the dots (words) to tell a story (include a bunch of versions for replayability )

- One-up (having to build upon the last turn with something bigger and better until there’s just utter chaos)

- Gardening (pollinators?) (set collecting) (do something/take an action, this lets you roll, you’re trying to compete something-a garden maybe?)

- Rock paper scissors combat

- Dungeon maze (play phase 1 as the lich who’s laying out all the traps and shit and play phase 2 as an adventurer trying to get the prize in the center. Phase 2 on a timer maybe?)

- You’re a villain in an Agatha Christie style murder story- plan your crime (motive, means, opportunity, victim, red herring, the twist, etc).

- A pirate burying treasure

- You play each member of a group of people trying to operate a mecha

- Roll and write

https://itch.io/jam/shit-or-get-off-the-pot

[shinydmoon]

Hello lets just get this over with.

Here are the things that could fall under PolyShipping.

Yugioh:

Yubel x Jay x Jesse(except not really due to au)

Dimensionshipping(ArcV)[soulmate clause] also doesn’t actively ship it in personal Yugioh mass au.

LoZ:

4 swords Adventure manga. Aka the Rainbow 5[Soulmate clause]

May be Marin x Legend x Ravio?(i ship Ravlink and don’t have any problems with Marin so Hing poly as Galaxyclan says)

Rest:

Ccs- Toyou x Yue/Yuki. Split personality

Persona- SouYo when including Shadows(does this even count? Fudge if i know.)

Persona- Crow x Joker x Fox. … i just threw them together when making Hypnos au and eh. Sure? Really i don’t mind any PolyThieves pair besides Joker x Navi/Oracle. Those 2 are Siblings.

Persona au- (Moon moth)Mint x Nyx[split personalitys with Nyx aka the 14 Arcana shadows]

My own story: those 3. As i call them, the nextGen trio.

OH I FINALLY RECALLED SOMETHING!

Ygo GX: Ryou - Adicus - Green hair. The Occult seniors trio. They are not ocs And are 3 separate people.