How to undo delete rows in sql jobs

Typical Functions: Data Architecture: Leverage your 5+ years of experience in designing and optimizing database solutions. You’ll work closely with stakeholders to create a robust data architecture that seamlessly integrates various data sources. Programming Languages: Demonstrate proficiency in Java and C#. Your code is not just functional but elegant. Team Leadership: As a seasoned engineer, you’ll mentor junior team members, foster collaboration, and drive technical excellence. Cloud Solutions: Familiarity with Azure or AWS is essential. You’ll architect, deploy, and manage cloud-based solutions. Data Import Strategy: Devise a robust strategy for importing data efficiently, ensuring data quality, and maintaining performance. Collaboration: Work cl...

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

I'm in need of a skilled professional to create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the

I'm looking to create an application using NoCode development tools, specifically Bubble and FlutterFlow. The core features I need developed are: - User Authentication: This will be based on an email and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I...

Hi Azabache Producciones , As previously discussed...Producciones , As previously discussed we'd like this video edited in a similar style to Matt Starky's :// I have provided a Guide Edit for timings and rough placements. A clean 4K resolution hosted recording - with same timings as the Guide. I've also included all screenshots and stock within the Guide Edit, but am open to you suggestions if you think other images or graphics might be better. Please let me know if there is anything missing. We'd like the design to fit on a page like this https://www.freelancer.com/ai-for-business so tonally and colour wise it should feel like it belongs to this page.

I want to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface ...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and di...

...cards with qr codes. I want to create a web app with following functionality would it be possible, 1. Landing page where public can view my products. To buy them they must sign up and fill out their details along with customisation to the physical card. physical card contains a qr code which will not change so i want it to be a redirect site so that user can change the link which the card points to. Something along the lines of this site kzilla.xyz. i don't need the front end just need the functionality of customisation of the link. Its open source so you can refer their github repo. When anyone scans the qr code on the card they would be taken to a page where it says a thank you for using this card you will be redirected in a f...

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

...words) carrier's 40% weighting in the Transportation Studies module and will be assessed by an individual report submitted via canvas. In your report you would need to include the experimental and the model results of your selected noise barriers. You will be judged on how you have been innovative in your conceive, design and how you improved the performance rating of your noise barrier. Assessment Criteria 1) Conceive (research noise barriers) = weight age (10%) 2) Project 1: Performance of reflective/absorbing noise barriers = weight age (40%) 3) Project 2: Traffic noise mapping = weight age (40%) 4) Modelling of noise barrier = weight age (10%) Project Details: Project Description: We are seeking a skilled freelancer to assi...

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know what's going...

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic pr...

I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this exciting project.

As discussed in chat I am ready to make changes in exam result of students As you want some fixes and some new rows with student division and grades and averages and need to calculate whether the student is passed or not.

I need a simple form that will look good on a small screen iPhone and also a big...NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and will then revert form back to a page that says success, and then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and veri...

...developer with expertise in .NET and Angular to take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing t...

I'm in need of a basic website with an integrated shopping cart to sell various products related to our charity club no more than 10 products. This will include items like memberships, event tickets, and club badges, totaling to about ten products. We will need to be editable by us, to be able to add and delete events, sponsors, products etc. Ok if you do it on a website building platform. It will have the following pages Home Image and text Store up to 10 products Events A page where we can add and remove events just an image and text Founding members Just a list of names Sponsors page. Logo and writing About us Text Contact Text We will provide all logos and photos where required. Ideal skills needed: - E-commerce si...

I need a professional to scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in data ...

I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete ...

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilitie...

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

...have a better chance. Monthly salary will be considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject ...

...Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the job to someone else to do, then DO NOT BID ON THIS, YOU ARE JUST WASTING YOUR TIME. This is a full time job, so hourly is low because...

...ethical hacker to test the security of my PHP-based website. I particularly need to ensure the website is compliant with OWASP Top 10 standards. Key Requirements: - User Authentication Testing: Verify the strength of our user authentication methods. The chosen freelancer should be able to effectively identify and exploit vulnerabilities in our user login process. - Authorization Controls Testing: We need thorough testing on the authorization controls in place to ensure that only authorized users can access specific resources. - Input Validation Testing: We need someone who can identify any weaknesses in the input validation of our website. This is crucial in preventing common security vulnerabilities like SQL injection and...

As an online learning provider, I offer a broad range of technical courses. I'm seeking an experienced sales person with an understanding of technical courses to drive the business forward. Key courses: - Web development - Data science - Embedded systems - Cyber security - Digital marketing - Auto CAD - Adobe Photoshop - Robotics - SQL - AWS - Data structures and algorithms Ideal candidate should possess: - Proven sales experience in the e-learning or tech industry

...main functionality would be to forward SMS/Text messages to other SMS, Telegram, and email addresses. Key Objectives: - App development competence in cross-platform development primarily focusing on iOS and Android smartphones. - The app should have the ability to forward incoming SMS/Text messages to other SMS numbers, Telegram, and email addresses. - An eye for detail to design a professional and corporate-looking app to resonate with our company's ethos. Ideal Expertise: - Expert in iOS and Android development - Experience with integrating third-party messaging and email services - Strong graphic design skills to create a professional and corporate aesthetic. Requirements: - app starts with system / smartphone...

...experienced developer to extend my existing PHP SQL driven platform. This project revolves around adding innovative features to the current structure. . Your job will include: - Analyzing the current structure and proposing alterations to accommodate the new functionalities robustly. - Implementing these suggestions after my approval with special emphasis on maintaining the overall performance & responsiveness of my website. To be an ideal fit for this project, you should: - Have previously worked on expanding PHP SQL based platforms. - Be capable of producing detailed project proposals. Apply with your most detailed project proposal, including your understanding of this task, estimated timeline, milestones, and why you think you'...

...looking to expand my phone unlocking website by integrating a Dhru Fusion API portal(currently only have a PHP portal). The goal is to connect with my suppliers efficiently and broaden my service portfolio. Key Objectives: - Integrate Dhru Fusion API portal: This will allow us to connect with suppliers and import specific services, including IMEI unlock services and credit top-ups. - Display Services: The imported IMEI services and credit top-ups from suppliers should be accurately listed with pricing on my website for customer ease and transparency. When customer places order it will send it straight thru to suppliers site fetch result and display it for customer Imei and server services will be able to be edited to allow me to ch...

I am in need of a skilled 3D modeller who can help me create a 3d model of a bike OLA S1 pro on Fusion 360. specifications Software : Fusion 360 Sub-divisonal topology 1 3d model 2 Renders of the model.(1920x1200 min, Must be Raytraced) No ngons, T points, Triangles File check-list- F3D source file File is clean (remove linked components, delete render-only assets) Name components/bodies appropriately History remove any unused nodes and try to fix errors (yellow or red highlights)

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

...unstructured product data from Oracle to SQL. This project requires a comprehensive understanding of database architecture, data migration best practices, and extensive knowledge of Oracle and SQL. Key Tasks: - Analyze and understand the structure of existing Oracle database - Prepare a thorough plan for data migration ensuring minimal downtime - Coherently migrate mixed structured and unstructured product data to SQL Ideal Skills and Experience: - Previous experience with Oracle to SQL data migration - Understanding of both structured and unstructured data - Deep knowledge of database architecture and design - Ability to troubleshoot any issues that arise during migration - Excellent attention to detail and precision is...

...tablet /phone. It must be able to print from iPad , iPhone etc. ( PDF print) It needs to have clean design UI. Preferred hosting on Linux web server (hosting provider) Application would be used to enter customer orders that are taken over the phone or in person. (Employee will enter customers info and order) (NO PAYMENT processing or customer access) Employee and admin level (Employee cannot delete order, only void) Customer (First Name, Last Name, Phone Number, Note ) (Option to import/export customers would be great) (from Excel file) Item/Product: (Product Category, Product name, SKU, Price) (Option to import/export Products from Excel file) would be great) Workflow would be: Login to App (email and password) (Option ...

...developer who can assist in the development of my platform. The ideal candidate will have experience in software development (language) and be passionate about creating high-quality Responsibilities: Collaborate with us to design and develop the platform . Write clean, efficient, and maintainable code. Test and debug software to ensure functionality and performance. Work on constructive feedback. Stay up-to-date with emerging technologies and best practices. Requirements: Proficient in Java, J2EE, Spring MVC, Spring Core, Spring boot and JavaScript. Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA, Hibernate) 5+ years of hands-on experience in designing, developing, testing and maintaining RESTful APIs a...

...that connects to our Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL...

I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that ...

I would like the attached jpeg modified: 1. The bars in front of Trump are on all 4 sides and the top like he is in jail. 2. The guy next to him is on the left side of the picture outside of the jail. 3. A bubble shows him say: Can't I get out while my guilty verdict is being appealed? 4. He is a lot closer to the camera. The rest of the jpeg is the same except you might have to leave some out to make him closer and bigger. I will hire more than one person so please bid even if I have hired someone else. How long to make it and how many revisions do I get? Sorry, if you don't answer this question for your first chat message I will assume you are a spam bot and delete the bid. "Hi" doesn't ...

...looking for a professional writer to draft a comprehensive, easy-to-follow guide on how to "l7as tizi" for personal use. The final output must be a text-only document. Key requirements include: - Comprehensive: The guide should cover all aspects of "l7as tizi" that are crucial for a beginner to know. - Easy-to-Follow: It should be written in a clear, concise, and engaging manner. Avoid using technical jargon or overly complex language. - Personal Use: The guide is intended for my personal use, so it should be tailored to suit my needs and knowledge level. Ideal skills and experience for this project include: - Proven experience in technical writing or creating how-to guides. - Excellent wr...

I'm looking for a talented...illustrative Instagram graphic for my latest blog post titled "How to Get Your Business Phone Registered to Avoid Spam Labels". Key Requirements: - Minimalistic Design: The graphic should be clean, simple, and in line with a minimalistic aesthetic. - Illustrative Style: I'm looking for an illustration rather than a photographic or typographic design. - Business/Communication Elements: Incorporating telephone or mobile icons into the design is a must. The design should subtly communicate the main theme of the blog post without being overly busy or cluttered. The winner will be asked to provide a Canva template, so please design your samples in Canva. Here's the blog post:

...means for our employees to access, update and input additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - Prior experience building work order or similar task management apps. Ideal candidate has worked on p...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

...assist me with a combination of SQL and Python tasks. - SQL: I need help with SQL in three specific areas: 1. **SQL Syntax:** Assistance with basic SQL commands, especially in working with subqueries. 2. **SQL Queries Optimization:** You should be able to optimize SQL queries for data retrieval accuracy. Your goal should be to ensure that the data collected is as accurate as possible. 3. **SQL Database Design:** You should be able to assist with database design, ensuring proper schema design and normalization. - Python: While the primary focus is SQL, some tasks may require basic Python knowledge. If you are proficient in both SQL and Python, even better. **Ideal Skil...

I need to delete the building highlighted in yellow in the photo and replace it with a field of vines of which all files attached

I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server ma...

...and their corresponding grades, each in a single row. I need a script that enables a user to input a unique pupil ID to look up their information, displaying only that specific row. The script should also include the following functionalities: - Show a direct link to the data in the selected row on another sheet, namely 'mywork sheet'. Ideal Skills and Experience: - Proficiency in Google Apps Script. - In-depth understanding of Google Sheets functionalities. - Experience in creating interactive scripts for Google Sheets. - Ability to build clear user interface for data lookup. - Familiarity with data linking across sheets. And in my words below I have a list of names on a Google sheet. - Pupils and their ...

At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank statement row.

Seeking an experienced PL/SQL developer to assist with multiple tasks in my project. This includes: - Oracle database management - XML table manipulation - JSON parsing - Dynamic SQL operations - Development of PL/SQL objects - Utilization of collections and arrays in PL/SQL The project will also involve intricacies such as: - Error handling and exception management - Performance optimization - Crafting of database triggers and stored procedures - Harmonious integration with other systems - Performing data migration and transformation tasks Ideal freelancers for this project should be adept in PL/SQL and Oracle development, with particular skill in SQL*Plus and PL/SQL Developer tools.