Dynamically retrieve Oracle Schemas and Tables using AngularJS

In this Oracle AngularJS tutorial I have tried to perform some basic DBA tasks, like populating all schemas within database and all tables within a selected schemas and display data of tables dynamically with dynamic column name display. I am also providing you the code for the angularjs and oracle data retrieving jsp file, download it from googledrive.

[parthasarathyshanmugam]

Hi @subhroneel, Video is very nice bro. Keep it up. i have tried using ng-option for getting the data like this..
//This 2 line is working fine
<tr><td>Select Table Name</td><td><select ng-model="optTable_U" ng-options="table.TABLE_NAME as table.TABLE_NAME for table in tables_U"

<tr><td>Select Primary Key Column</td><td><select ng-model="optPrimCol_U" as column.COLUMN_NAME for column in columns_U"

//From this not working.. Dont know whats wrong in this.. Can you please help me(Not Retrieving the data from Oracle DB)Is there any problem in ng-option .

<tr><td>Select Primary Key Column Value </td><td><select ng-model="optPrimColVal_U" as employee.EMPLOYEE_ID for employee in columnsVal_U" ></select></td></tr>

<tr><td>Select Column Name to be Updated </td><td><select ng-model="optCol_U" as columnname.COLUMN_NAME for columnname in columnsCom_U"



JS Content for this :

//Update Functionality
distinct table_name from user_tables order by 1")
.success(function(response) {
$scope.tables_U = response;
});



$scope.getColumnNames_U = function(){
column_name FROM all_cons_columns WHERE constraint_name = (SELECT constraint_name FROM user_constraints WHERE UPPER(table_name) = UPPER('" + $scope.optTable_U + "') AND CONSTRAINT_TYPE = 'P')")
.success(function(response){
$scope.columns_U = response;
});
}

$scope.getColumnNamesVal_U = function(){
"+$scope.optPrimCol_U+" FROM "+$scope.optTable_U+"")
.success(function(response){
$scope.columnsVal_U = response;
});
}

COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME='" + $scope.optTable_U + "' ")
.success(function(response){
$scope.columnsCom_U = response;
});


$scope.getDataType_U = function(){
DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME='" + $scope.optTable_U + "' ")
.success(function(response){
$scope.DataType_U = response;
});
}


Bro ... Kindly help me bro