Introduction
Check the given below code where developers can create a web method to get the Table Details from an Oracle Database.
[WebMethod]
public static List<string> GetTableName(string prefixText)
{
List<string> result = new List<string>();
try
{
String connString = ConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString;
OracleConnection conn = new OracleConnection(connString);
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OBJECT_NAME LIKE '" + prefixText.ToUpper() + "%'";
cmd.Connection = conn;
conn.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result.Add(reader["OBJECT_NAME"].ToString());
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}