I work in a team developing a .NET code in VS environment as well as an Oracle database in PL/SQL. Now we want to use the Team Foundation Server as version control getting help of Oracle Developer Tool so that we can store both database and the code in one place. My question is that is there any possibility to "check in" the changes on both database and the code just by one tag? so that we realize in the future that those changes are related to one bug.
TFS will let you check in any file, if it was a Sql Server database then you could have your c# code in one project and your sql code in another project in the same solution and then it would be really simple to check in all the code together.
Because there isn't a project type for PL/SQL you should export your schema / code to individual files which you could either add to a different type of project or not include them at all but just have them on the file system under a folder within the solution.
In TFS (VS 2013) the pending changes allows you to see either changes just within the solution i.e. files that are included in a project or all changes that happen in the file system under the solution so you can see all changes and then check them in with one check-in.
I often create additional folders under a visual studio solution with projects that can't be opened using visual studio and use other tools to manage them but use visual studio to check them into source control and it works really well.
For VS2013 - one thing to add is that when you check in, if the changes aren't shown in "Included Changes" - under "Excluded Changes" there is a button "Detected: XX add(s)" - if you go into that you can promote changes outside of the solution so that they are included.