Welcome To Snipplr
Everyone's Recent Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
PL/SQL
Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user
I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.
0
1422
posted 13 years ago by theonlyalterego
This snippet is "extension method" for IDataReader.
You can use this snippet below ;
I assume you have datareader like that
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.IsColumnExists("columnName"))
{
//do something...
0
1423
posted 13 years ago by emregulcan
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0
761
posted 13 years ago by tuffo19
You can use TSQL to Count Number Of Stored Procedures, Views, Tables or Functions in a Database by using the Database INFORMATION_SCHEMA view
0
5256
posted 13 years ago by Mithun
Not that theres anything new to this. In fact its very old fashioned, but If you like me forget how its done; snip it.
0
905
posted 13 years ago by fengelz
This was a school project, so it is not well commented but feel free to ask details.
0
1003
posted 13 years ago by sp4ke
This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier)
If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity .
So, I write a trigger...
1
759
posted 14 years ago by emregulcan