我需要将以下SQL查询从SQL服务器转换为oracle
问题描述:
USE [Database_Name]
CREATE proc [dbo].[spGenerateDBDictionary]
AS
BEGIN
select a.name [Table],b.name [Attribute],c.name [DataType],b.isnullable [Allow Nulls?],CASE WHEN
d.name is null THEN 0 ELSE 1 END [PKey?],
CASE WHEN e.parent_object_id is null THEN 0 ELSE 1 END [FKey?],CASE WHEN e.parent_object_id
is null THEN '-' ELSE g.name END [Ref Table],
CASE WHEN h.value is null THEN '-' ELSE h.value END [Description]
from sysobjects as a
join syscolumns as b on a.id = b.id
join systypes as c on b.xtype = c.xtype
left join (SELECT so.id,sc.colid,sc.name
FROM syscolumns sc
JOIN sysobjects so ON so.id = sc.id
JOIN sysindexkeys si ON so.id = si.id
and sc.colid = si.colid
WHERE si.indid = 1) d on a.id = d.id and b.colid = d.colid
left join sys.foreign_key_columns as e on a.id = e.parent_object_id and b.colid = e.parent_column_id
left join sys.objects as g on e.referenced_object_id = g.object_id
left join sys.extended_properties as h on a.id = h.major_id and b.colid = h.minor_id
where a.type = 'U' order by a.name
END
有人可以帮我翻译这个sql server查询到oracle
我尝试了什么:
i尝试了在线翻译但没有工作
can somebody help me in translating this sql server query to oracle
What I have tried:
i have tried online translator which didnt work
答
这是一个在线转换器: Microsoft SQL Server到Oracle迁移 - SQLines [ ^ ]
按绿色转换按钮进行转换。
Here is an online converter: Microsoft SQL Server to Oracle Migration - SQLines[^]
Press the big green Convert button to convert.