(888) 812-6318
Let's Talk.
M&S Consulting Logo

Tag

oracle sql

SQL LIKE – Oracle LIKE Operator – SQL Syntax Examples

The reserved word LIKE in Oracle SQL represents an operator that performs some basic matching on text. LIKE provides a utility to conduct simple text pattern matching without the full power regular expressions, and hence, is simpler than using regular...

Oracle TO_CHAR Function – SQL Syntax Examples (Most With Dates, TO_DATE)

This article provides common examples of TO_CHAR using dates.

Oracle Rename Column – alter table, rename column Example SQL Syntax

Following is simple example syntax for renaming a column to an Oracle table using "alter table" SQL:

ALTER TABLE [my_table_name]
RENAME COLUMN [current_column_name] TO [new_column_name];
A simple example would be: 
Oracle SUBSTR with INTSR Function – SQL Syntax Examples
Oracle SUBSTR and INSTR SQL functions are typically used together in practice for parsing a string.  Following are some examples uses that will exemplify how to take... 
Oracle TO_DATE Function – SQL Syntax Examples
The Oracle TO_DATE SQL function is used to convert a TEXT or NTEXT representation of a date into an Oracle DATETIME value.

Below shows the TO_DATE function along with the arguments it takes:


to_date(string)



Oracle INSTR Function – SQL Syntax Examples
The Oracle INSTR SQL function is popular and performs materially the same operation as instr functions in many other programming languages.

Below shows the INSTR function along with the arguments it takes:


Oracle Rename Table – Example Syntax and Dependencies
Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax: 1 ALTER TABLE current_table_name RENAME TO new_table_name; In practice, you might realize you left off a prefix that you are using as a naming standard. Changing the table name can be... 
FreeQL – Free Oracle SQL Select Statements
M&S Consulting has begun a revolutionary service where we will write Oracle SQL statements for FREE.  We have named this service FreeQLTM.

ms_freeql_logov1
1234
Search

	

				

			
		

		
		

	


Blog Tags
11g
actionscript
adobe flex
asp.net
bi and reporting
cloud computing
company
crm
dogma
downloads
etl
google
identity management
industry news
in the trenches
iphone
jdeveloper (jdev)
liferay
microsoft
MySQL
open source
Oracle
oracle adf
oracle apex
oracle application server
oracle apps (ebs)
oracle architecture
oracle bam
oracle bpa suite
oracle dev
oracle discoverer
oracle portal
oracle soa bpel
oracle sql
oracle xe
process and workflow (bpm)
recent work
salesforce.com
sql server
ssis
video training
virtualize and vm
web 2.0
webcenter
weblogic


		

	
 
		
 
		

		


		
							

				

					

						
		
		
Recent Blog Articles
		
		
Twitter
			
			
		
Quick Contact
			










Your Name*

     


Your Email*

     


Your Phone

     


Your Message*

     





		
Let’s Get Social
						

					
 
				

			
 
		
		
							

				

					

						

							© 2002-2013 M&S Consulting. All rights reserved.						
 
						

							WV • DC • NY • OH • CA • MD • VA •  IL • MA • HI 

 Morgantown • Cincinnati • Boston • Frederick • NYC • San Francisco