DB version is: Oracle 12c. Restricted to the use of inline PL/SQL.
The end goal here is to get a count of open items by day, inclusive of created date, exclusive of the end date.
The data structure is approximately:
| id | open_date | close_date |
|----|------------|------------|
| a | 01/...
Once upon a time there was a noob developer who learned it all by himself because he grew up in a nation far behind in IT.
I've tried to learn C# for about 5 years, without any improvement over the last two. Then i decided to use you! StackExchange community.
Every time i try to write code i wi...
During a discussion in a development chat, a user suggested to another (in the context of C# originally),
UserA: Challenge: Create an implementation of RPS, and then show how it can be extended to include an unlockable option Bomb (blows up paper and rock, but scissors cuts the fuse - basical...
This is my code for gomoku. I made it with javascript and html. I think the checkWinner function can be improved or make shorter. Also the functions should be re-organized? Here is the code.
Javascript:
var turn = 0;
var width = 15;
var height = 15;
var gameOver = false;
var board = Array(width...
I am beginner of java. I want to add table output. Folder list and output result. How can i do that?
import java.io.File;
public class CheckEmptyDirectory
{
public static void main(String[] args)
{
String str[] = {"\\Directory1",
"\\Directory2",...
};
for (int i=0; i<str.length;i++) {...
I was working on an assignment in my Python class to sort 10 numbers but I wanted to be able to sort any set of numbers be it large or small. The assignment didn't really cover any sorting algorithms other than bubble sort so I started working and decided to just do something simple find the smal...
i have this code for validate address from input
and its a sample address
2 جنت آباد جنوبی- پایین میدان چهارباغ-ساختمان سبز- پلاک 148- واحد
in this case my output is
جنت آباد جنوبی میدان چهارباغ ساختمان سبز
im just need to speed up it
public function validateMethod1($address)
{
...
I have a class with a various set of optional parameters when instantiated.
I would like to be sure that the user input ONLY the available parameters option, and also add a default value if nothing is passed.
I come with this
export enum HexagoneType {
POINTY,
FLAT
}
export interface Hexag...
I have been trying to find defects (brown/copper parts) on this sample using PyQt, OpenCV and Python:
And I can find defects, too. My problem is, I have nobody to ask, get feedback etc. I need some feedback about my code. Of course, I don't want someone to review my code line-by-line, but even...
I wrote some function to compare the duration taken for 1000 loops. Just wondering if the comparison is right? For the thread, I want to set to maximum 3 thread. Thread is core, right? Task took the longest time which seems not correct.
using System;
using System.Diagnostics;
using System.Linq;
...
On Eric Amodio's website and the JS.ORG website, there is a nice javascript animation which makes text appear/disappear as if it is being typed. I tried to replicate something similar but far more basic on JSFiddle. In my experiment, the words Code review appear typed, are hidden by toggle(200), ...
This is a project I've been working on and it's my first so please feel free to just copy this into python and give this a try.
Below you'll find the main code and a small bit on rules and how to play, Enjoy!
If you have any queries about the game or any other games that are soon to be released l...
I have some doubts with the following code that implements a SignalR endpoint that receives and sends messages.
Basically the ISendValuesService produces new values and raises a NewValueRegistered event whenever it does. Upon this event the SignalR hub sends a message to all connected clients th...
Last December I interviewed with Storj and was unsuccessful after my code challenge. Storj were good enough to pay me for the time it took to complete the challenge, but have refused to give any kind of feedback as to where or why my submission was not up to their standards.
The repo for this co...
I am trying to write an abstraction layer to validate uploaded files on the project.
There will be one factory who will handle to build the constraints
One another service to validate uploaded files using the builded constraint from the factory
namespace Infrastructure\Service\Asset;
/**
* Cr...
I have written a function that compares two version number strings (e.g. 1.2.0 and 1.2.2) and return 1 if the first string is greater, -1 if the second string is greater and 0 if the strings are equal for a code challenge that I'm attempting.
Also, it's guaranteed that both strings contain an eq...
I am new to Kotlin and am trying to learn and understand this development.
So I am trying to understand how would I refactor the below code to do the following :
1. get rid of the reference to answerList and change processAnswerButtonClick to take an index
2. toggle answer.isSelected = !origIs...
how to get this result to a text box named "txtBx3"
int val4;
// int val5;
val4 = int.Parse(txtLeaves.Text);
if (val4 > 24)
I have been working through Introduction to Algorithms 3rd Edition, and have implemented an AVL tree through prototypal inheritance. The code presented here does work as expected based on the tests that I currently have.
What I am looking for
Review of overall implementation in terms of effici...
Goal: a decorator that calls the wrapped function and catches any errors, including any errors that might occur by awaiting the result. Must be synchronous to wrap sync functions, and also handle awaiting async function results.
export function NoThrow(_target: any, key: any, descriptor: Proper...
I have given the Mars Rover challenge a go in Python. I am still relatively new to Python so know this is a bit basic - but I wondered if I could get some general feedback on my code for best coding practice?
class MarsRover():
RIGHT_ROTATE = {
'N':'E',
'E':'S',
...
I am working on a Nagios Scraper in Python3. I have Github set to automatically run checks (i.e. Python Linter) to make sure the code is good. It is currently failing that check, although the code works.
When I check with a PEP8 checker online, I am getting constant warnings about `line break be...
In an api I'm building, I have multiple routes that require an agency to exist before any action is performed on the requested agency.
To avoid repetition I've written some middleware to check that the agency does indeed exist before continuing (and throws if it does not).
The code I have work...
