Rewrite existing procedure without merge as Oracle 12.1 doesn’t support it

I have a procedure where data is pushed into table using merge logic used as part of it. The procedure takes string passed at runtime and splits it into rows.

I need to change the merge part using any other method other than merge, maybe cursor for loop as Oracle 12.1 does not support merge and similar take input string and insert/update accordingly in the destination table. inside procedure and we cannot get it upgraded due to constraints.

So everything in proc would be same just that it would be without merge.

The details are inside the fiddle with table and sample data.

https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=34a88972aa53cf60b1199f9f277285f4

previous_posts_link & next_posts_link doesn’t generate any output

Hey I am using a WPQuery to loop through and show blog categories in posts. It’s in a page tempplate. has 21 posts and I want them to show 10 per page with navigation links for next pages of 10 posts but below code is not outputting that buttons

enter image description here

<div class="container-blog-post d-flex flex-wrap justify-content-start">          <?php  $  paged = ( get_query_var( 'paged' ) ) ? get_query_var( 'paged' ) : 1;         $  args = array(             'post_type'      => 'post',             'category_name'  => 'blog',             'posts_per_page' => 10,             'orderby'        => 'date',             'order'          => 'DESC',              'paged' => $  paged         );          $  the_query = new WP_Query( $  args ); ?>          <?php if ( $  the_query->have_posts() ) : ?>              <?php while ( $  the_query->have_posts() ) : $  the_query->the_post();                    if(has_post_thumbnail()) {                     $  image = get_the_post_thumbnail_url();                 }else{                     $  image = get_template_directory_uri().'/assets/images/default.svg';                 }                                             $  url   = get_permalink();                 $  title = get_the_title();                 $  text  = excerpt(20);                 $  date = get_the_date();              ?>                                <a href="<?php echo $  url; ?>" class="single-post card">                 <figure class="image-wrapping">                   <img src="<?php echo $  image; ?>" alt="">                 </figure>                 <div class="body-post card-body">                   <h3 class="title-post card-title"><?php echo $  title; ?></h3>                   <p class="card-text line-clamp-2"><?php echo excerpt(10); ?></p>                   <button class="btn-read-more arrow">Read more</button>                   <div class="button-post">                     <span class="date-post"><?php echo $  date; ?></span><span class="author-post"><?php echo the_author(); ?></span>                   </div>                 </div>               </a>                <?php endwhile; ?>                      <div class="previous">                 <?php previous_posts_link(); ?>         </div>         <div class="next">             <?php next_posts_link(); ?>         </div>             <?php wp_reset_postdata(); ?>         <?php endif; ?>        </div> 

How do I set application_name so that it doesn’t get the “?” characters?

I have this UTF-8 string in PHP:

$  test_title = 'My criticál business applicätiön'; 

If I send that to PostgreSQL to set the application_name, it then looks like this:

My critic?l business applic?ti?n 

If I try to salvage it by transliterating like this before sending to PG:

$  test_title = iconv('UTF-8', 'US-ASCII//TRANSLIT', $  test_title)); 

Then I get:

My critic'al business applic"ati"on 

Basically just as bad. It tries its best to represent the UTF-8 characters as the US-ASCII charset that PG demands for the application_name, but it just doesn’t look right. It cannot possibly look right because US-ASCII simply doesn’t contain all the non-USA characters.

Unfortunately, there also exist people outside of the USA. (I know, it’s annoying, but it’s sadly true.)

I refuse to believe that application_name must be ugly like this. It cannot be. It’s too stupid to be true. I must be missing something. There has got to be some way to set application_name to the actual application name and not have it butchered in the above manner.

Basically, I don’t "buy" that PG would be this primitive and crippled still in year 2020.

Box2D simulation doesn’t work

I previously used Box2D and it always worked fine until recently I decided to test how it would work in my custom 2D game engine, I just wanted to test the physics updates without any GUI interaction, as you can see in the below code I just try to print the plain position values of the dynamic body and it just doesn’t move. All it does is print the initialisation position I set in the initialiser, afaik all I’m trying to do it print the values in a simple loop that runs more than 60 times per frame, the box2d code doesn’t interact with the rendering in anyway. IDK what’s wrong with box 2d to run fine in a simple loop. I’m really confused why the simulation isn’t happening. Let me know if you need more info about anything.

Freefall.h

 #include <fireworks/fireworks.h>  #include <box2d/box2d.h>  using namespace fireworks;  class FreeFall : public Fireworks { private:     Window*         m_Window;     Layer*          defaultLayer;      b2Vec2          m_Gravity;     const double    m_PhysicsTimeStep = 1.0f / 60.0f;     unsigned int    m_VelocityIterations;     unsigned int    m_PositionIterations; public:     b2World* world;      b2BodyDef       groundBodyDef;     b2Body*         groundBody;     b2PolygonShape  groundShape;     b2FixtureDef    groundFixtureDef;      b2BodyDef       dynBoxBodyDef;     b2Body*         dynBoxBody;     b2PolygonShape  dynBoxShape;     b2FixtureDef    dynBoxFixtureDef;      Sprite*         ground;     Sprite*         dynBox; public:     FreeFall()         : m_Gravity(b2Vec2(0.0f, -29.81f)), m_VelocityIterations(6), m_PositionIterations(2)     {         world = new b2World(m_Gravity);         // Static ground body         groundBodyDef.position.Set(0.0f, -10.0f);         groundBody = world->CreateBody(&groundBodyDef);         groundShape.SetAsBox(20.0f, 4.0f);         groundFixtureDef.shape = &groundShape;         groundFixtureDef.density = 1.0f;         groundFixtureDef.friction = 0.3f;         groundBody->CreateFixture(&groundFixtureDef);          // Dynamic simulation box         dynBoxBodyDef.type = b2_dynamicBody;         dynBoxBodyDef.position.Set(-1.0f, 4.0f);         dynBoxBody = world->CreateBody(&dynBoxBodyDef);         dynBoxShape.SetAsBox(2.0f, 2.0f);         dynBoxFixtureDef.shape = &dynBoxShape;         groundFixtureDef.density = 1.5f;         dynBoxFixtureDef.friction = 0.25f;         dynBoxBody->CreateFixture(&dynBoxFixtureDef);     }      ~FreeFall()     {         delete defaultLayer;         delete world;     }      // Runs once per initialisation     void init() override     {         m_Window = createWindow("Freefall physics sim", 800, 600);         glClearColor(0.8, 0.8f, 0.2f, 1.0f);               }     // Runs once per second     void tick() override { }      // Runs 60 times per second     void update() override { }      // Runs as fast as possible     void render() override     {         //Physics Update         world->Step(m_PhysicsTimeStep, m_VelocityIterations, m_PositionIterations);         b2Vec2 dynPos = dynBoxBody->GetPosition();         std::cout << "dynnamic Box2d Box position X : " << dynPos.x << " and Y is : " << dynPos.y << std::endl;     } }; 

MainGame.cpp

#include "physics-sims/Freefall.h"  int main() {     FreeFall game;     game.start();     return 0; } 

This is the output I get : dynnamic Box2d Box position X : -1 and Y is : 4 for as long as the loop runs, this is soo infuriating, IDK what’s breaking what.

Ways to run net runners that doesn’t monopolize time?

We have started a cyberpunk red game and one of our party is a net runner. However we have found the game slows down while he is doing his thing. It doesn’t seem to be the players or DMs fault it is just the nature of the mechanics of hacking to allow us access to somewhere, get information out, turn off alarms or cameras or take control of the systems.

It can result in a 10-15 min break while the DM and Netrunner make all the various rolls and decisions. If there are 3-4 hacking attempts in a session this can eat up slot of time. It isn’t just us that feel this the DM and Netrunner are also conscious of the fact.

Is there a way to streamline this at all? Our netrunner has suggested writing an app linked to roll 20 that the DM can use to set up hacking challenges so the net runner can then sit and do it by himself while the DM carries on with the rest of us. But are there any suggested mechanics or ways to speed up net running?