Skip to content
Magenaut

Magenaut

  • Home
  • Topics
    • Notes
    • Tutorial
    • Bug fixing
    • Extension
    • Server
  • Q&A
  • Privacy Policy
  • About

plsql

How to convert MYSQL to PL/SQL

November 29, 2022 by Magenaut

This is my MYSQL code. Here I want to convert This to PL/SQL

Categories MySQL, Q&A Tags mysql, oracle, plsql Leave a comment

Converting Oracle SQL Procedure into MySQL Stored Procedure

November 24, 2022 by Magenaut

I am trying to convert a complex oracle sql procedure to mysql. The procedure contains of many differenct selects, cursors etc. I already wrote a version of it in mysql, but it does not work and only gives some error messages. I hope on could help me.

Categories MySQL, Q&A Tags mysql, oracle, plsql, stored-procedures Leave a comment

What does it mean by select 1 from table?

November 21, 2022 by Magenaut

I have seen many queries with something as follows.

Categories MySQL, Q&A Tags mysql, plsql, sql Leave a comment

How to handle a query with special characters / (forward slash) and (backslash)

November 19, 2022 by Magenaut

I have a table where a column allows special characters like ‘/’ (forward slash) and ” (back slash).

Categories MySQL, Q&A Tags mysql, plsql Leave a comment

Query to update one column based on the amount of another column

September 6, 2022 by Magenaut

I have a table with below structure :

Categories Database Administrators, Q&A Tags oracle, oracle-11g-r2, plsql, query, query-performance Leave a comment

Recent Comments

  • silverplugins217 on How to add placeholder for contact form7 for dropdown?
  • Shreyas Ikhar on How to add a custom CSS class to core blocks in Gutenberg editor?
  • Magenaut on How to call function on timer ASP.NET MVC
  • Ebaad Uddin on How to call function on timer ASP.NET MVC
  • michealSmith07 on Is there a way to dynamically refresh the less command?

Tags

.net adobe-illustrator adobe-photoshop ajax arrays asp.net asp.net-core asp.net-mvc bash c# css database django eloquent express html java javascript jquery json laravel laravel-4 laravel-5 laravel-8 linux list mongodb mongoose mysql node.js npm pandas php python python-3.x react-hooks react-native react-router reactjs redux regex sql string typescript wordpress
© 2023 Magenaut • Built with GeneratePress