Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL - Page 4

PL/SQL
  SQL
Transact-sql
61-80 of 615     Previous     Next
Retrieve the Month's First Day for a Date
by Amit Vij
This code shows you how to retrieve the month's first day for a date.
Fetching Even and Odd Records in Oracle
by MS Sridhar
This tip will help you understand how to apply the mod function and use it to obtain even and odd records from columns in Oracle.
Identify "Drop Out" Columns Used in Stored Procedure Definitions
by Jaya Nehru Kumar
Find out an incredibly easy way to identify dropped out columns used in stored procedure definitions.
Count the Number of Rows in Two Tables Using a Single Query
by Sanjay Agarwal
Learn three different ways to count the number of rows in two tables using a single query.
Display Table Information
by Neeraj Tyagi
See the code that allows you to display all your table's information.
The Purpose of the GO Statement
by Sachin Kainth
Although GO is not a T-SQL statement, it is often used in T-SQL code and unless you know what it is it can be a mystery. Find out its purpose in this tip.
Dealing with Wildcard Characters in Oracle
by MS Sridhar
The ESCAPE keyword comes handy when you have a character in your data which is same as a Wildcard character.
Retrieve All Columns from Each Table in Every Database
by Mohammad Khan
This stored procedure retrieves all the columns of each table in every database.
Retrieve Records from a Supplied SQL Statement
by Syed Mohamed
Learn how to retrieve records from a supplied SQL statement.
Finding a SQL Server Object
by Srinath MS
Use this code to find a SQL Server object, even if the database name is unknown.
Selecting One Record Before and After a Value
by Srinath MS
Find out how to select one record before and after a value.
Find the Total Number of Tables in an MS Access Database
by Jaya Nehru Kumar
Use the code in this tip to find the total number of tables in an MS Access database.
Convert Descriptive Flex Fields to Numbers
by Kamlesh Jethwa
Often, data in Oracle applications is stored in extended columns known as Descriptive Flex Field (DFF) columns.
Determine Whether a Given Column Name Is an Identity or Not
by Vadivel Mohanakrishnan
This tip lists two ways in which you can find out whether a given column name is an identity or not in SQL Server.
Determine How Many Times a String Is Found Inside Another String
by Zarko Jovanovic
This tip shares a fucntion that can help you determine how many times a string is found inside another string.
Handling Null Values in Oracle
by MS Sridhar
Find out how using NVL in your queries is better for displaying information and helps avoid front-end processing.
Determine the Type of Modifcation Operation on a Table
by Sachin Kainth
Find out how to use the INSERTING, DELETING and UPDATING trigger predicates to determine the type of modifcation operation that's been performed on a table.
Turning Recursive and Nested Triggers On and Off
by Sachin Kainth
This tip gives you the commands to switch recursive and nested triggers on and off.
Presenting Dates in Varying Formats
by Sridhar MS
Dates are generally a requirement for every application. However, including dates for users across the globe can be tedious, because different people use different formats to read the date.
Getting New Values Entered into a Table
by Sachin Kainth
Find out how you can use :new.<fieldname> to retrieve new values entered into a table.
61-80 of 615     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date