background preloader

Instant SQL Formatter

Instant SQL Formatter
Plugin for Notepad++UltraEditeclipse1.1KShare Instant SQL Formatter (Ver4.0.2 Updated: 09-19-2014) Database Output: Enter your sql code here... Short Video 1 Short Video 2 After Before Before with space Stacked Not Stacked Align left Align right And/Or under Where Remove Linebreak before beautify Trim Quoted Char of Each Line quoted char of eachline: Compact the output of sql output Related:  Tools

List with audio converter tools SQLZOO Learn SQL using: SQL Server, Oracle, MySQL, DB2, and PostgreSQL. Reference: how to... How to read the data from a database. 2 CREATE and DROP How to create tables, indexes, views and other things. 3 INSERT and DELETE How to put records into a table, change them and how to take them out again. 4 DATE and TIME How to work with dates; adding, subtracting and formatting. 5 Functions How to use string functions, logical functions and mathematical functions. 6 Users How to create users, GRANT and DENY access, get at other peoples tables. 7 Meta Data How to find out what tables and columns exist. 8 SQL Hacks Some SQL Hacks, taken from "SQL Hacks" published by O'Reilly 9 Using SQL with PHP on Amazon EC2 servers Video tutorials showing how to run MySQL, PHP and Apache on Amazon's EC2 cloud servers. 10 An introduction to transactions Video tutorials showing how sessions can interfere with each other and how to stop it. 11 Using SQL with C# in Visual Studio

365 Jours - Tutoriaux vidéo et ressources sur la création de site Web JRockit JRockit, a proprietary Java Virtual Machine (JVM) originally developed by Appeal Virtual Machines and acquired by BEA Systems in 2002,[1] became part of Oracle Fusion Middleware in 2008. The JRockit code base and the HotSpot virtual machine from Sun Microsystems (now Oracle) are currently being integrated, with the target of releasing a JVM with a combined code base around the release date of JDK 8. JRockit was made free and publicly available in May 2011. Many JRE class files distributed with JRockit exactly replicate those distributed with HotSpot. History[edit] Following the finalization of the acquisition of Sun Microsystems, Oracle announced in JavaOne 2010 that the best features of JRockit would be implemented in OpenJDK[2][3] In May 2011, Oracle announced that JRockit has become free, confirming that they plan to port JRockit features on OpenJDK[4] Performance[edit] Oracle claims[5] that using JRockit can give significant performance gains. Supported CPU types[edit] References[edit]

Backwards Text Generator ToggleCase cuts out all the hassle of manually figuring out what words to type backwards to create Reverse Text. Simply type or paste any words you want to convert into the form below, hit the magic Backwards Text button and that's it. Then just copy and paste your Reverse Text to use elsewhere. Easy! Have fun with ToggleCase and create crazy and wacky Reverse (Backwards) Text messages online for your Twitter, Facebook, and MySpace posts (or anything else for that matter). Transform from this chunk of text in Sentence Case: ToggleCase is the coolest website ever! To this chunk of text in Reverse (Backwards) Text: !? Accueil - COLIBRI Strasbourg – Cours Libres Interactifs Ruby Programming Language In defence of SQL | Seldo.Com Blog If this title does not interest you, here are some alternative, linkbait titles: Why ORM is the Dumbest Idea Ever Why NoSQL is a Terrible Idea OMADS: the future of data storage Why SQL Will Eventually Conquer The World A little history SQL was invented in the 1970s at the same time that "large-scale" (read: millions of rows) data stores came into existence. It triumphed over other query languages not because it was particularly great (though it was easier to read), but because it was standard. SQL is awkward There's no escaping that SQL, as we use it day to day, is not pretty. Keep in mind that what SQL is really designed to express is relational algebra, a type of logic essentially invented by the ridiculously clever E.F. What it's not really for is collating, aggregating, and most especially filtering of data sets. So you're right. What about ORM? I want to be very, very clear about this: ORM is a stupid idea. This is obviously silly. OMADS: data stores that match the application Post-SQL

Text To NATO Phonetic ToggleCase cuts out all the hassle of creating NATO Phonetic Alphabet text from standard, everyday speech format. Simply type or paste any words you want to convert into the form below, and hit the magic Phonetic Alphabet button. Then just copy and paste your NATO Phonetic Alphabet text to use elsewhere! Have fun with ToggleCase and create crazy and wacky NATO Phonetic (Military & Police) Alphabet messages online for your Twitter, Facebook, and MySpace posts (or anything else for that matter). Transform from this chunk of text in Sentence Case: ToggleCase is the coolest website ever! To this chunk of text in NATO Phonetic (Military & Police) Alphabet: Tango Oscar Golf Golf Lima Echo Charlie Alpha Sierra Echo India Sierra Tango Hotel Echo Charlie Oscar Oscar Lima Echo Sierra Tango Whiskey Echo Bravo Sierra India Tango Echo Echo Victor Echo Romeo !

C++ Language Tutorial This website uses cookies. By continuing, you give permission to deploy cookies, as detailed in our privacy policy. ok Search: Not logged in C++ Language These tutorials explain the C++ language from its basics up to the newest features introduced by C++11. Introduction Compilers Basics of C++ Program structure Compound data types Classes Other language features C++ Standard Library Input/Output with files Tutorials C++ LanguageAscii CodesBoolean OperationsNumerical Bases C++ Language Introduction:CompilersBasics of C++:Program structure:Compound data types:Classes:Other language features:Standard library:Input/output with files A case for ANSI SQL Intro Hi there! This is my first post on the blog. I will cover Oracle SQL and PL/SQL topics. For lack of inspiration, I dubbed it "The Oracle Experience" (like The Jimi Hendrix Experience) because Oracle databases rock, of course. The ANSI way If you've worked with Oracle databases for some time, you might have heard of ANSI SQL syntax. For me, there are three good reasons to use ANSI SQL syntax: ANSI SQL syntax is 1. ANSI SQL syntax is clearer because the "ON" that joins the tables occurs in the from clause next to those tables, not among other restrictions in the where clause. The ANSI syntax is more direct when you need a full outer join between two tables. Demo Tables I will use the Employees and Departments tables from the HR sample schema. Joining tables Using the demo tables, we want to write a query that displays the employees and their departments. Traditional syntax Query Results This is a simple example. Outer joining tables Selbat gninioj retuo Third base

7 Animated white board If you're in marketing, design or advertising, at some point you might need use an animated cartoon whiteboard video to present an idea. Unlike a static presentations the key to this medium is keeping the customers attention and illustrating ideas in a flowing natural stye. A whiteboard or scribble video is made with a variety simple effects: A hand writing the words across the screen with a marker A hand using a marker to draw a cartoon Images popping in and out Camera swings, pans and zooms Cartoon charters with speech bubbles. You get the idea. Prezi: Prezi is the least impressive of the bunch. Video scribe: Video scribe does a great job of the effect of someone writing words across a screen or drawing a picture and is easily able to import .svg files and "draw" them by hand (although it only draws the outline and then the colours auto-fill, the effect is still quite good). Fiverr: Fiverr is a marketplace where you can buy many marketing and advertising services. Pow Toon: Go Animate: OK.

datejs - A JavaScript Date Library Last updated 2008-04-14 Datejs is an open source JavaScript Date library for parsing, formatting and processing. The last 'official' release was Alpha-1 on November 19th, 2007. The project has been under active development since that time and many revisions and additions have occurred. It is highly recommended that you obtain a copy of the latest source from SVN. Technical support is provided through the Datejs Discussion Group. A test suite is available within SVN (/trunk/test/) or viewable online at View Change Log. NOTE Please be sure to check out our blog post "Getting Started with Datejs". We recommend including one of the .js files from within the /build/ folder. Within the /build/ folder, a date.js file has been created for each of the 150+ supported Cultures. Before minification, the Datejs library is contained in five (6) separate JavaScript files. The following is a list of precedence if including the files individually. 1. Syntax Overview Parsing Chaining

3 Data Pump Import This chapter describes the Oracle Data Pump Import utility. The following topics are discussed: This section provides descriptions of the parameters available in the command-line mode of Data Pump Import. Many of the descriptions include an example of how to use the parameter. Using the Import Parameter Examples If you try running the examples that are provided for each parameter, be aware of the following requirements: Most of the examples use the sample schemas of the seed database, which is installed by default when you install Oracle Database. If necessary, ask your DBA for help in creating these directory objects and assigning the necessary privileges and roles. Syntax diagrams of these parameters are provided in Syntax Diagrams for Data Pump Import. Unless specifically noted, these parameters can also be specified in a parameter file. Command-Line Escape Characters in Examples Some of the examples in this chapter may show certain clauses enclosed in quotation marks and backslashes.

Related: