Pl sql block example in oracleJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Skapa en header navbar (Röd med vit bold text) med namn devilsuited (center) Och body backround svart. Gå till Youtube besök min Youtube kanal embed mina första tolv heads-up videos. Skapa two-column Layout (ui-grid-a, two columms 50%/50% Corresponds To ui-block-a|b) önskemål om du kan skapa att varannan är two columms 50%/50% där två videos visas bredvid varandra. Om du kan göra dem till 170/120px. Och sedan vill jag ha en annons på 340/240 px som visas 100% nedanför sen two columms 50%/50% tills du kommer upp i de tolv video. (Jag laddar upp banners till dig) Jag vill att när man klickar på en video att den tar upp hela skärmen och att man kan kryssa ner och komma tillbaka till sidan...

Objective of the task: inventory of the entire sheet of the basic map of a fragment of Ursynów, Warsaw, Poland, including all of the elements of land development. Task content: Georeference the base map based on the files in the Ursynów folder () with an accuracy of 10 cm (use a minimum of 44 geodesic crosses). Remember the frame data and coordinate system (2000-PL). Create a file geodatabase to store all object classes. Create layers (feature classes) within the geodatabase and vectorize all of them objects visible on the base map, i.e. buildings, trees, lawns, roads, slopes, stairs, elements buildings, sheds, garages, sandboxes, waste bins, etc. (minimum 15 layers). There can’t be any empty spaces so choose the layers to vectorize wisely. After vectoriz...

...management. Develop advanced scenarios, dashboards, and analytics in the platform. Integrate Kinaxis with ERP systems (e.g., SAP, Oracle) and other enterprise applications. Stakeholder Collaboration Work with business leaders, supply chain teams, and IT to gather requirements and define project scope. Communicate complex technical concepts to non-technical stakeholders. Provide thought leadership on best practices and industry trends. Technical Leadership Guide and mentor project teams, including developers and analysts. Troubleshoot complex issues and optimize performance. Ensure compliance with security, data governance, and architectural standards. Project Management Define project timelines, milestones, and deliverables in collaboration with project managers...

...& Engineer Job Type: Freelance / Remote Experience: 4+ years in Azure Cloud architecture and implementation Job Description: We are seeking a highly skilled Azure Cloud Solutions Architect & Engineer with comprehensive expertise in Azure infrastructure, security, networking, identity management, automation, and scripting. The role involves designing, implementing, and managing a secure and scalable Azure environment using best practices such as Landing Zones, Management Groups, CI/CD pipelines, and Infrastructure as Code with Terraform. You will be responsible for managing Azure Virtual Desktops (AVD), automating workflows, and ensuring security and high availability across Linux and Windows environments. Additionally, expertise in Azure Security and Azure S...

I'm looking for an expert in EMC NetWorker to assist with configuring backups for my Oracle database files. Key Requirements: - Extensive experience with EMC NetWorker and Oracle database systems - Proven track record in backup configuration tasks - Able to identify and backup all necessary database files Please only apply if you have the relevant skills and experience. Thank you!

Hi, we need translators for English to Bahasa Indonesian language for a technical document. Pl write if you are natve and experienced. Thank you.

I'm seeking an expert in setting up Google Cloud, AWS EMR, and Apache Airflow. Your responsibilities will include: - Setting up infrastructure: You'll need to build a robust and scalable cloud infrastructure tailored to our needs. - Writing custom scripts: This will involve scripting in Python to meet our specific data handling requirements. - Data processing workflows: You will design and implement efficient data processing workflows using Airflow. Main project is to create views from google bigquery dataset and read it in aws emr using Workload identity federation ,create airflow jobs and then dump it to sql server. Shall be expert in terraform scripting as well Your expertise in these areas will be critical to the success of this pro...

I need a professional resume tailored for a mid-level Data Engineer. The focus should be on SQL skills, particularly query optimization. Experience with ETL processes, data pipeline design, and database management should also be highlighted. Key requirements: - Design and writing experience with tech-oriented resumes - Strong understanding of data engineering roles and skills - Proficient in showcasing mid-level experience convincingly - Excellent command over English and resume-writing conventions

I'm seeking an expert to assist with an examination task that encompasses both SQL queries and ORM diagram creation. Key Requirements: - Proficiency in SQL, particularly with MySQL - Experience in designing and creating ORM diagrams - Capability to work with simple data structures, specifically simple tables Ideal Skills: - Strong understanding of relational database concepts - Excellent problem-solving skills - Ability to work under pressure and meet deadlines

...WordPress website, almost every two minutes. This seems abnormal and I suspect it's a bot issue. I've temporarily deactivated the registration page, but the flow of registrations continues unabated. I need an expert to investigate this issue, block these unwanted registrations, and fix the root of the problem. Key Tasks: - Identify the source of the spam registrations - Implement measures to stop these registrations - Fix the issue so I can safely re-enable the registration page Ideal Qualifications: - Extensive experience with WordPress - Proficient in identifying and mitigating spam/bot issues - Familiarity with security and anti-spam plugins for WordPress - Able to provide long-term solutions to prevent recurrence Your expertise is urgently needed to help ...

We...talented programmer with a solid background in Delphi, Devex, and SQL Server to join our team. If you’re someone who loves coding and has experience building apps and managing databases with these tools, we want to chat! Your role will involve writing code, fine-tuning SQL queries, and ensuring our software works smoothly together. If you’re passionate about what you do and have a track record to back it up, we’d love to hear from you! Key Responsibilities: - Fix bugs as they arise in the existing applications. - Implement feature updates as required. - Improve application performance, with a primary focus on code efficiency. Ideal Skills & Experience: - Proficient in Delphi, Devex and SQL Server. - Experienced in...

I need a professional to set up a SQL Server failover cluster for 10 applications, all running on Windows Server. This will be for a UAT environment and will involve a quick proof of concept on 2 nodes. Key Requirements: - Setup of SQL Server failover cluster - Testing of the setup as a proof of concept - Evaluation of the SQL Server version used by each of the 10 applications The ultimate goal is to achieve an 'always on availability group' level of high availability. Ideal Skills: - Extensive experience with SQL Server - Familiarity with Windows Server - Knowledge of high availability configurations - Ability to conduct a proof of concept Successful completion of this initial setup and testing will lead to a contract for the full project.

...security initiatives, implementations, and integrations. Additionally, the resource will drive application and infrastructure security within multiple platforms to minimize application vulnerabilities and application risk: •Safeguard software applications from potential threats and breaches •Bridge between security and development, ensuring that applications are designed, developed, and deployed in a secure manner •Identifying and fixing security vulnerabilities •Proactively identifying potential security risks, developing mitigation strategies, and ensuring that security measures are incorporated right from the beginning of the application development process •Automating security: automating scans, code verification, and other security processes •De...

...user base, but requires ongoing updates, bug fixes, and potential feature enhancements. Technology Stack: Frontend: The website uses React with for server-side rendering, which helps in optimizing load times and SEO. Experience with JavaScript, TypeScript, and modern CSS frameworks like Tailwind CSS or styled-components is essential. Backend: While primarily frontend-focused, some backend knowledge would be beneficial. Although specifics aren't provided, familiarity with RESTful APIs or GraphQL could be useful for data fetching or integration with external services. Database: Knowledge of SQL or NoSQL databases would be advantageous for handling any database operations if required for new features or data management. Deployment: The site is likely hosted on platform...

I'm seeking an expert in 3D visualization to help with a project for my wood trading company. We need a realistic 3D depiction of a truck made entirely of processed wood for a marketing presentation. Key Requirements: - The truck should be depicted as entirely constructed from processed wood, with visible wood grain. - The wood should be represented as a solid, processed block rather than tree trunks, boards, or slats. - A medium to darker wood color is preferred for a realistic look and to minimize soiling on the visualization. - The final output should be a series of static images from multiple angles, achieving an effect as close to reality as possible. Goals: - If the concept is convincing, the next step will be printing these images onto marketing materials. - An ...

...Responsibilities: Analyze and resolve data duplication issues in inventory and client-stored wine records. Generate and review reports to identify discrepancies in purchase orders (POs) and sales orders (SOs). Collaborate with internal teams to reconcile discrepancies between Xero and Wine Owners. Propose and implement solutions, including script-based corrections, to rectify the migration dataset. Provide guidance and recommendations to prevent future data migration errors. Work closely with our ERP partner, Wine Owners, to ensure all adjustments align with system requirements. Requirements: Proven experience in ERP data migration and troubleshooting, preferably with platforms like Wine Owners or similar inventory management systems. Expertise in SQL...

...summary block of woocommerce in wordpress site. The price should show a list of product bundle which has files with prices of one time payment and some files like supscription which should show monthly price base. I am not using supsrciption plans on the site, also dont need to setup payment gateways because I dont sell at this moment, just collecting leads. Maybe the shipping class options could save the problem by adding unique classes to the different products. I already use a plugin to show up the prices (for example before price label "mtl" stands for monthly), but in the cart and checkout summary it dont loads the function of the current used plugin for custom price label. Some sites using sales funnel where you can for examle choose a smartph...

...reinforce secure logins. • Usage Restrictions • Block social media, streaming sites, and any inappropriate or non-business-related websites. • Allow only business-critical apps and websites (primarily Microsoft 365 suite and any other approved tools). • HIPAA Folder Protection • Some employees need HIPAA compliance for certain folders in SharePoint; ensure access is locked down and logs are recorded appropriately. 2. Personal Devices (BYOD) • Limited Company Data Access • We do not plan to enforce full MDM or MAM policies, but we do want to ensure that when employees access company files or emails, our data remains secure. • App/Email Security • Configure policies (e.g., Conditional Access, if feasible) to protect corp...

I'm looking for a skilled video editor to create a project similar to the example video provided here: Here’s what I’ll provide: - The lyrics for the video. - Video clips to be used. - Background music. Your role would be to: - Edit the video by combining the clips, music, and lyrics so they sync seamlessly. - Ensure the final product has a style and feel similar to the example video. If you can replicate this style and bring the project to life, I’d love to work with you! Please share examples of similar work if available. We would start with this project. From there, I would want you to create between 1 - 5 videos monthly.

I am dealing with slow queries, particularly when querying a very large number of records from multiple tables. While I have identified so...expert who can deeply analyze the situation, identify the root cause of the problem, and implement effective solutions to improve overall database performance. Ideal candidates should have: - Extensive experience as an MS SQL Database Administrator - Proven track record of diagnosing and resolving database performance issues - Ability to optimize query performance and improve system efficiency - Strong skills in performance tuning and database optimization techniques - Familiarity with MS SQL Server Management Studio and other relevant tools. - You need to have knowledge in .NET EF Core A proper candidate needs to have a...

I need a skilled professional to set up a two-node Oracle 19c RAC database on Oracle VirtualBox 7.14 for a test environment. Key Requirements: - Host System: Windows 11 powered by Intel i5 12th Gen with 64 GB RAM - Install Oracle Linux Server 8.8 on both cluster nodes, assigning 12 GB RAM to each - Configuration of ASM with specified disk groups: - OCR: 3 GB - DATA: 30 GB - RECO 20 GB - Installation of Oracle 19c Grid software - DNS setup can be ignored - Use of Automatic Storage Management (ASM) for disk groups I have the Oracle Linux Server 8.8 ISO ready, and no special network settings are needed for the cluster nodes. The ideal freelancer for this project should have extensive experience with Oracle databases, VirtualBox, and Linux s...

I'm facing CORS issues while integrating my Oracle Apex application with a REST API. The data exchange is primarily in JSON format. The ideal candidate for this project should: - Have extensive experience with Oracle Apex. - Be highly proficient in REST API integrations. - Possess a strong understanding of CORS errors and how to troubleshoot them. - Be capable of working with JSON data. Your task will be to resolve the CORS error so that I can successfully integrate with the external REST API. Please be prepared to demonstrate your troubleshooting skills and API integration expertise.

I am seeking a seasoned SQL Server Administrator to assist with database maintenance tasks, specifically focusing on backup and restoration. Your primary responsibilities will include: - Performing a one-time backup and restore of the database. Ideal candidates should have extensive experience in SQL Server management and database maintenance. Excellent problem-solving skills and attention to detail are essential.

We are seeking an experienced Oracle Integration Cloud Specialist with a Good understating in OIC integration patterns, knowledge of OIC connections and connection configuration role (Trigger, Invoke, Trigger and Invoke), OIC fault handling (Fault Handler) Required Qualifications: * Minimum of 7 years of hands-on experience in OIC activities like Stage file, Local integration invoke, Wait, Fault activity. Various operation supported by stage file activity (list files, zip etc.) * Good hands-on experience in SOAP, REST, DB, FTP, ERP connections in OIC. Various operations supported by FTP connection (download, list files). DB connection implementation in OIC orchestrated integration. * Good hands-on experience in either FBDI based integration ...

...evaluate my .NET and SQL based ERP software. The testing should cover: - Functionality: Ensure all features are working as intended. - Performance: Assess the speed and efficiency under various conditions. - Security: Identify any potential vulnerabilities. I need the testing to be conducted from the perspective of: - Admin: Tests should simulate actions and interactions of a system administrator. - Manager: Tests should reflect the experience and tasks of a managerial user. Additionally, the testing should encompass various database operations, including: - CRUD operations: Verify Create, Read, Update, Delete functionalities. - Code: Testing should extend to the software's code base for any potential issues. The ideal candidate will have extensive experience with .NET...

...complex SQL queries to retrieve, aggregate, and analyze transactional data from the eCommerce database. Performed data normalization and optimized queries for faster processing. Created schema diagrams to map out relationships between products, customers, and orders for better data understanding. Tableau: Built visually appealing dashboards for trend analysis on customer behavior, product performance, and seasonal demand. Used advanced features like parameters and calculated fields to enable dynamic filtering and forecasting. Published and shared dashboards with stakeholders for collaborative decision-making. Impact: Improved inventory management by identifying high-demand products and underperforming SKUs. Boosted customer retention by analyzing and addressing key drop-off poi...

**Overall Test Planning & Execution** - Develop test strategies, test plans, and test cases for the Baidu Click and Filtering System, ensuring that the system meets the expected functionality and performance in data collection, real-time detection, and offline analysis. **Automation Testing & Tool Development** - Develop and maintain automation testing scripts and tools for modules such as click data monitoring, anti-fraud detection, and machine learning models. - Build an automated testing framework integrated with the CI/CD process to ensure continuous testing and prompt feedback. - Create Python-based tools for automated testing, ensuring secure handling of data and incorporating encryption/decryption functionalities as needed. **Test Environment Setup & Attack S...

I'm experiencing logical errors in the business logic of my SQL Server stored procedure. These errors occur during specific queries. I need an expert to diagnose and fix the issue.

I am encountering intermittent network connectivity problems with my Oracle RAC setup and need an experienced Oracle RAC Administrator to assist with troubleshooting and support. - Primary Task: Troubleshooting network connectivity issues. - Specific Focus: Resolving intermittent connection drops affecting the Oracle RAC. The ideal candidate will have a strong background in Oracle RAC, with proven experience in troubleshooting network connectivity issues. Experience with Java connectivity is a plus. The goal is to restore stable network connectivity and prevent future interruptions. The problem I am encountering is Java programs keep encountering 'The Network Adapter could not establish the connection at ()'. However the issue

I'm seeking a skilled cybersecurity professional for a thorough penetration test on my website and app. The testing will be conducted from a White Box perspective, meaning you will have complet...and app. The testing will be conducted from a White Box perspective, meaning you will have complete knowledge of the systems and networks involved. Key focus areas: - Identifying vulnerabilities such as SQL injection, Cross-site scripting (XSS), and Authentication flaws. - Testing critical areas of the application, including User authentication, Payment gateway, and Database security. Your expertise in these areas will be crucial in ensuring the security of my application and protecting it from potential threats. Please provide examples of similar projects you've c...

...browse, enroll in courses, and track their progress. Content Delivery: Integrate a video streaming service or securely host video content. Implement functionality for document uploads (PDFs, slides). Payment Integration: Integrate a payment gateway (Stripe or PayPal) for purchasing courses. Ensure secure handling of financial transactions and data. Real-time Features: Implement real-time chat or discussion forums for course interaction. Use WebSockets or similar technology for live class sessions. Deployment: Deploy the backend to a cloud platform like Heroku or AWS. Deploy the frontend to a platform like Netlify or Vercel. Ensure the portal is optimized for performance and scalability. Security & Optimization: Ensure the application is secure from common vulnerabilities...

: --- ### Job Description: Baidu Click and Filtering System Test Engineer **Overall Test Planning & Execution** - Develop test strategies, test plans, and test cases for the Baidu Click and Filtering System, ensuring that the system meets the expected functionality and performance in data collection, real-time detection, and offline analysis. **Automation Testing & Tool Development** - Develop and maintain automation testing scripts and tools for modules such as click data monitoring, anti-fraud detection, and machine learning models. - Build an automated testing framework integrated with the CI/CD process to ensure continuous testing and prompt feedback. - Create Python-based tools for automated testing, ensuring secure handling of data and incorporating encryption/d...

...The application can be created completely in this technology, or can only be used for back-end, eg in the form of web API. Even so, the project must meet the conditions of use of MVC, multilayer architecture, object programming. Also, the SQL code line must not appear in the web project to separate the web page and database code (the exception is the call of SQL procedures - but make sure you know what "SQL procedure" and "call SQL procedures"! Creating a multilayer application, ie. At least the layers of presentation, Application, Infrastructure and Domain must be included. All functionality must be created and used using services (Services). In the presentation layer there must be no direct use of infrastruct...

...responsiveness across all browser viewports. - Achieve optimal scores for all Core Web Vitals metrics and ensure WCAG 2.0 AA compliance. Additional Information - Create reusable block patterns or templates for easy site-wide adaptation. - Provide improvement suggestions based on performance, design, or usability observations. I will share a full screenshot of the current homepage, and every aspect of the existing design needs to be kept unchanged; this includes all visual elements and text content. The ideal freelancer for this task should have: - Extensive experience with WordPress and the Ollie theme. - Proficiency in using native WordPress Gutenberg blocks. - Strong understanding of Core Web Vitals and WCAG 2.0 AA standards. - Excellent attention to detail ensures com...

I'm seeking a skilled techno-functional consultant with expertise in Oracle Fusion Cloud ERP, particularly in the Purchase Orders module. Key Responsibilities: - Assist in writing and optimizing OTBI queries across various modules including Inventory, Purchase Orders, Sales Orders, and Financials - Primarily focus on the Purchase Orders module Ideal Skills: - Proficient in Oracle Fusion Cloud ERP - Extensive experience with OTBI - Strong techno-functional background - Excellent query writing skills - Understanding of Purchase Orders module

Add 3D model, add sample world information, give overall block diagram and tap points (such as sockets, interface, etc)

Cyber Ballet seeks dynamic and experienced freelance trainers/consultants to deliver impactful training programs for a long-term state government contract focused on developing a skilled and productive workforce. We are seeking professionals with expertise in a range of interconnected areas, including workplace wellness, interpersonal skills, communication, customer service, leadership development, career development, safety, labor relations, technical skills, project management, and facilitation services. Travel Expectations: This is a primarily remote role with occasional on-site training throughout Delaware. Travel frequency and duration will vary based on client needs. Willingness to travel within Delaware is required. Reasonable travel expenses will be reimbursed according to ...

...Application (Electron for Windows & macOS) 3. Back-End (Node.js/Express or NestJS + PostgreSQL) Overall Project Goals • Create a unified codebase (using JavaScript/TypeScript) for both web and desktop. • Deploy a cloud-hosted back-end (Node.js + PostgreSQL) so no local database installations are needed for end-users. • Ensure a scalable foundation to eventually add mobile apps via React Native in a future phase. Scope & Requirements 1. Back-End • Node.js (TypeScript preferred). • Express or NestJS for building a REST (or GraphQL) API. • PostgreSQL as the primary database. • Database models for property management (e.g., properties, units, tenants, payments, maintenance). 2. Web Front-End • React (TypeScript preferred) f...

I need to create SQL connections using the pdocrud WP plugin and a PHP insert script plugin. I have a database ready, but I require some custom SQL statements to produce user-specific results based on the horse selected. When a user logs into wordpress , the horse dashboard page will be available, and on that page a drop down will show all the horses the user has created and will have selected default horse - then that horse id and user id wil displ;ay all revelnt data in tables using WP pdocrub plugin . This will just start the project—I will need more complex code later, but I want to see how this will work compared to my current site. please only bid what it will cost. dont bid 50.00 an then tell it will be 800.00 Key Requirements: - Custom SQL...

I'm looking for a skilled data visua...looking for a skilled data visualization expert to design a Tableau dashboard primarily for sales analysis. The dashboard will be used by analysts to derive insights and make informed decisions. Key Requirements: - Proficiency in Tableau with a strong portfolio of previously designed dashboards - Expertise in sales analysis - Excellent understanding of data visualization principles - Ability to design intuitive dashboards for analysts Data Sources: The dashboard will draw data from various sources, predominantly Excel/CSV files and databases (SQL, NoSQL). Experience in integrating these data sources into Tableau is crucial. Please note that the primary users of the dashboard will be analysts, so the design should ca...

RESOLVER EJERICIOS DE: Diseño Esquema Modelo Relacional Algebra Relacional SQL Pasaje de MER a MR

I'm seeking a WordPress expert to implement several enhancements on my site, These include: 1) Integrating Jetpack to display math formulas across the site. 2) Utilizing the Gutenberg Code Block for efficient code presentation. 3) Setting up and configuring member subscription features for premium content access, email subscriptions, and contributor/editor roles. Ideal candidates should have extensive experience with WordPress, Jetpack, and the Gutenberg Code Block. Familiarity with configuring member subscription features is a plus. Please provide a portfolio of similar projects you've completed, along with your bid.