Blog

How to fix the Oracle error ORA-16708: the state supplied to broker is invalid?

In this post, you’ll learn more about the Oracle ErrorORA-16708: the state supplied to broker is invalid with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-16708: the state supplied to broker is invalid Reason for the Error ORA-16708: the state supplied to broker is invalid The state name specified was invalid for the database….

InterSystems IRIS TSQL Code 15225 No item by the name of ‘%s’ could be fou

In this post, you’ll learn about the SQL error code 15225 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 15225 Reason for the Error code 15225 in InterSystems IRIS DBMS No item by the name of ‘%s’ could be found in the current database ‘%s’, given that @itemtype was input…

InterSystems IRIS TSQL Code 3718 Could not drop index ‘%.*ls’ because the

In this post, you’ll learn about the SQL error code 3718 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 3718 Reason for the Error code 3718 in InterSystems IRIS DBMS Could not drop index ‘%.*ls’ because the table or clustered index entry cannot be found in the sysindexes system table.

InterSystems IRIS General Error Code – 7334

In this post, you’ll learn about the General error code 7334 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 7334 Reason for the Error code 7334 in InterSystems IRIS DBMS Unable to read file, Backup or Restore is in progress

InterSystems IRIS General Error Code – 2043

In this post, you’ll learn about the General error code 2043 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 2043 Reason for the Error code 2043 in InterSystems IRIS DBMS Could not add new member when the Async member connected

Inner Join in SQL Server

You can use inner join to get the result of two tables that match the criteria. For example , assume that you have a Person table and a Phone Number table where every person would have 0 or more phone number associated to him and you wish to get the person records who have at least one phone number. Here’s the query on how to…