SQLize
Online
/
PHPize Online
/
SQLtest Online
A
A
A
Share
Donate
Blog
Popular
Donate
A
A
A
Share
Blog
Popular
SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code.
You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.
SQL code:
Upload
Copy
Format
Clear
CREATE TABLE tabl_1( Makat nvarchar(22) NOT NULL,Description nvarchar(59) NOT NULL); INSERT INTO tabl_1 (Makat, Description) VALUES(20202028 ,'BAL LONAHTE'); INSERT INTO tabl_1 (Makat, Description) VALUES(40-0015 ,'%5 redwop animula no muidohR'); INSERT INTO tabl_1 (Makat, Description) VALUES(40-1010 ,'RBK-EDIMORB MUISSATOP'); INSERT INTO tabl_1 (Makat, Description) VALUES(2000042 ,'L1-RA ENEULOT - פיה רחבה'); INSERT INTO tabl_1 (Makat, Description) VALUES(40-1100 ,'slatsyrC enotaktooN larutaN'); INSERT INTO tabl_1 (Makat, Description) VALUES(40-0378 ,'CCB מנידוף לפלש'); INSERT INTO tabl_1 (Makat, Description) VALUES('3PBDMSBCC-0402' ,'LOB לנידוף XEH/FHT'); SELECT* FROM dbo.tabl_1 -------------------- с этой преременной в низу нужно создать функцию и использовать для замены столбца Description----- declare @NAME VARCHAR(300) set @NAME = 'טולואן מטיפול RLTC/BMA' DECLARE @POS INT DECLARE @HebrewWord varchar(200) DECLARE @EnglishWord Varchar(200) DECLARE @NewName Varchar(200) DECLARE @Found int -- initialazation set @HebrewWord = '' set @EnglishWord = '' set @Found = 0 set @NewName = '' set @NAME = ltrim(Rtrim(@NAME)) SELECT @POS = 1 WHILE @POS <= LEN(@NAME) --2 BEGIN if (ASCII(SUBSTRING(@NAME,@POS,1)) <> 32) begin IF (ASCII(SUBSTRING(@NAME,@POS,1)) < 224) begin SELECT @NAME = STUFF(@NAME, @POS, 1 , CHAR(ASCII(SUBSTRING(@NAME,@POS,1)))) set @EnglishWord = @EnglishWord + SUBSTRING(@NAME,@POS,1) set @Found = 0 --set @HebrewWord = '' --end if end else begin set @HebrewWord = @HebrewWord + SUBSTRING(@NAME,@POS,1) set @Found = 1 --set @EnglishWord = '' --end else end set @NewName = reverse(@EnglishWord) + ' ' + @HebrewWord IF SUBSTRING(@NAME,@POS,1)= '''' begin SELECT @NAME = STUFF(@NAME, @POS, 1 , '`') --end if end --end if (ASCII(SUBSTRING(@NAME,@POS,1)) <> 32) end else begin set @EnglishWord = @EnglishWord + ' ' set @HebrewWord = @HebrewWord + ' ' --end else end SELECT @POS = @POS + 1 --end while @POS <= LEN(@NAME) END select (ltrim(rtrim(@NewName))),@NewName --REVERSE (@HebrewWord) +@EnglishWord
SQL
Server:
MariaDB 11.4
MariaDB 11.5
MariaDB 10
MariaDB 10 Sakila (ReadOnly)
MySQL 5.7
MySQL 5.7 Sakila (ReadOnly)
MySQL 8.0
MySQL 8.0 Sakila (ReadOnly)
SQLite 3
SQLite 3 Preloaded
PostgreSQL 10 Bookings (ReadOnly)
PostgreSQL 11
PostgreSQL 12
PostgreSQL 13
PostgreSQL 14
PostgreSQL 15
MS SQL Server 2017
MS SQL Server 2019
MS SQL Server 2022
MS SQL Server 2022 AdventureWorks (ReadOnly)
Firebird 4.0
Firebird 4.0 (Employee)
Oracle Database 19c (HR)
Oracle Database 21c
Oracle Database 23c Free
SOQOL
Version
ER Diagram
Preserve result
Stuck with a problem?
Got Error?
Ask ChatGPT!
Result:
Copy
Clear