sql - How to run this query on Oracle Developer? -

I have this query as part of the PowerShell script and it runs fine on SQL Server but fails on Oracle Select

When OBJECT_ID (N'INTERFACE_DEFINITION ', N'U') is Zero, then 0 and 1 end

Here is an error: ORA -00923: Not Found by Keyword

Thanks

"text">

  Select the case when 'A' & gt; 'B' then dual to 0 and 1;  

Dual table is present in each oracle database. This particular table contains only one column column named Dummy, and has a datatype of VARCHAR2 (1). The dual table has only one line in that row, there is a value in the Dummy of 'X'

The purpose of the DUAL is simple - when you do not want to receive any data specifically, its Instead there is something to do to run a SELECT statement, but instead it is only willing to run a SELECT statement to accomplish some other work.

is making sure that any object exists:

  OBJECIDID (N'InterFACDFININT, 'N'U')  

In Oracle, you can use this query:

  Select count (*) from all_backs where object_name = 'INTERFACE_DEFINITION';  

all_objects does not necessarily show you all the objects in the database. It only shows the items on which the current user has a private group.