Follow us:
skip to main
|
skip to sidebar
Oracle Appplications
End to End Topics With SQL,PL/SQL,Reports,Forms,XML Reports,OAF,Oracle Apps
Home
SQL
PL/SQL
REPORTS
FORMS
ORACLE APPS
BI/XML REPORTS
OAF
APPS QUERIES
INTERVIEW QUESTIONS
Pages
Topics
SQL
SQL Introduction
SQL Create Table
SQL Table Alter
SQL Table Drop
SQL Table Truncate
SQL Table Rename
SQL Table Describe/Desc
SQL Table Insert
SQL Update Table
SQL Table Data Delete
Add Column in Oracle Table
Drop Column in Oracle Table
Rename Column in Oracle Table
Modify Column in Oracle Table
Insert Data into Oracle Table By Using Column Address
SQL operators
SQL IN Operator
SQL Like Operator
SQL Between Operator
SQL is NULL AND is NOT NULL
SQL Select Statement
SQL Commit
SQL Rollback
SQL Savepoint
SQL Grant and Revoke
SQL ALIASES
Conditional Selections and Operators
SQL Group By And Having
SQL Multiple Inserts
SQL Merge
SQL Numeric Functions
SQL Abs
SQL Sign
SQL Sqrt
SQL Mod
SQL NVL
SQL NVL2
SQL Power
SQL Exp
SQL Ln
SQL Log
SQL CEIL
SQL Floor
SQL Round
SQL Trunc
SQL Bitand
SQL Greatest
SQL Least
SQL Coalesce
SQL String Funcions
SQL Date Functions
SQL Group Functions
SQL Case
SQL Flashback
Oracle SQL joins
SQL Constraints
SQL Create Table Primary Key
SQL Create Table Foreign Key
Create SQL Table With Constrains
Alter Table add Primary key Oracle
SQL External Tables
Table Partitions
SQL Rollup Grouping Cube
SQL Set Operators
SQL Views
Materialized View
SQL Synonym
SQL Sequence
SQL Subqueries
SQL Exists
SQL Walkup Trees And Inline View
SQL Locks
SQL Indexes
SQL*Plus Commands
SQL Set Commands
SQL Practice Queries
DEPT and EMP Table Scripts
PLSQL
PL/SQL Introduction
PL/SQL Data Types
PL/SQL Variables
Operators in PL/SQL
Comments in PL/SQL
SQL Functions in PL/SQL
Displaying Information from a PL/SQL Block
First PL/SQL Program
Nested Blocks in PL/SQL
SQL Statements in PL/SQL
PL/SQL Record Type Variable Example
Manipulating Data in PL/SQL
PL/SQL Control Structures
PL/SQL Cursors
Oracle PL/SQL FOR LOOP>
Oracle PL/SQL Cursor Attributes
PL/SQL Cursor with Parameter
Oracle PL/SQL Implicit Cursor Attributes
Oracle Exceptions
Types of Exceptions in Oracle
PL/SQL Triggers
Procedures and Functions
Oracle Stored Procedures
Oracle PLSQL Functions
Difference between Procedures and Functionsa>
Oracle PL/SQL Packages
Mutating Tables
Pragma Autonomous Transaction
PLSQL Record
PL/SQL Ref Cursor
PL/SQL Bulk Collect And Bulk bind
Oracle Bulk Bind
Oracle Bulk Collect
PL/SQL Index by tables (or) PL/SQL tables (or) associative arrays
PL/SQL Nested tables
PL/SQL Varray
Difference among Index by table, Nested table and Varray
REPORTS
Oracle Reports Introduction
How to connect database from oracle report builder
Create Oracle report Using Wizards
Create Oracle Sample report Manually
how to add summary column in oracle reports
Formula columns in oracle reports
Placeholder Column In Oracle Reports
Create Report with Bind Parameter
Create Oracle Report with Lexical Parameter
Oracle report Triggers Order of execution and usages in Real time
Oracle Reports FAQS
FORMS
Oracle Forms Introduction
Oracle Form Items
Oracle Form Triggers
Oracle Form Debugging
How to connect database from oracle form builder
Create Oracle Form Wizard
Navigational Triggers Firing Sequence In Oracle Forms
Oracle Forms FAQS
ORACLE APPS
Concurrent Program Overview in Oracle Appsa>
How to create User in Oracle Applications R12
FNDLOAD Scripts
Fndload Command For Concurrent Program in R12
Request Group Fndload Command in oracle Applications
Fndload Form Download Upload Command
Fndload Form Function Download Upload Command
Fndload Menu Download Upload Command
Fndload Template for a Data definition Download Upload Command
Fndload Request Set Download Upload Command
Fndload Lookup Download Upload Command
Fndload Responsibility Download Upload Command
Fndload Personalization Download Upload Command
Fndload Value Set Download Upload Command
Fndload Profile Options Download Upload Command
Fndload alert Download Upload Command
Fndload Data template (Data Source.xml) Download Upload Command
Fndload RTF Template (report layout.rtf file) Download Upload Command
How to Submit a Concurrent Request from backend
Submit XML Report From Backend
Oracle Apps Important Queries
SQL Loader
UTL File
Value Set Types in Oracle Apps
What are the difference between KFF and DFF in Oracle Apps
Oracle Apps Tables and Use
Outbound Interfaces
PO Inbound Interface
Interfaces In Oracle Apps
Workflow in Oracle Application
Implementation And Support Projects Process steps
AIM methodology
Multi Org structure
How To Rise Service Request In Metalink
Functional Interivew FAQS
List of Tables for Forms Personalization
How to get Trace file for Concurrent Program
Form-Personalization in Oracle Applications
Alerts-in-Oracle Applications
How To Remove a Table From an Audit Group
How to Enable Audit Trail On Tables
FRM-92101 There was a failure in the Forms Server during startup. this could happen due to invalid configuration
How to get distinct values in table value set
How to Enable Diagnostics in Oracle Applications
How to find Application Top in Oracle Applications R12
Find Application URL From Database in Oracle App R12
BI/XML REPORTS
XML/BI Publisher Overview
Create XML Report By using Data Template
How to repeat the header for each and every page in XML Publisher
How To get grand total in XML/BI publisher
How To Show Different Header On First Page Of RTF Template
If then Else statement in BI/XML Publisher Reports
Page Breaks in BI/XML Publisher Reports
Defining Headers and Footers in BI/XML Publisher
How to Insert Images in BI/XML Publisher Reports
Sort Data in BI/XML Publisher Reports
How to Use Oracle SQL Functions in BI/XML Publisher Reportsa>
OAF
OAF JDeveloper Installation and Setting Environment
Oracle Application Framework(OAF) Architecture
How to remove substitution/extension to a VO object in OAF
How to Enable Personalization link for OAF Pages
Types of Packages which are Used in the OAF
APPS QUERIES
Query to find Responsibility for the Concurrent Program
Bounce Apache Server
Script to delete Concurrent program and Executable and Data definition and Template
Find the right responsibility for your concurrent program with OU for particular parameter
how to create user from backend in oracle applications r12
Unix command to create a soft link
How to Add Responsibility to User from Backend in Oracle applications R12
How to Reset User Password in Oracle Applications R12
How to find Password for FND User in Oracle apps R12
XML/BI Publisher report based on PL/SQL Stored Procedure
Concurrent Program Name with Parameter and Value set
Find Table and Column Name with table and column description
Encrypt and Decrypt Password in Oracle
Find IP Address and Host Name using PL/SQL.html
Find Concurrent Program Parameter Values for Last Run from Backend
Query To check Locks on a Table
Query to Find an Object Type
Query to Check for Existence Of Any Object In The Database
Query to Check Database for Invalid Objects
Query To Find Dependent Objects Of An Invalid Object
Query to Finding Columns and Tables
Query to Finding and Deleting Duplicate Rows
Query to Get The Code For a View
Query to Checking Version of Database Package
Query to View Code for a Package
Query to Display Package Errors
Query to Check to see what Indexes are on a Table
Query to Check to see what Columns are Indexed on a Table
Query to Find Triggers on a Table
Query to Find Directory where Trace Files are Stored
Query to Check for Multiple/Duplicate Logins
Query to Obtaining Org_Id and Setting Context
Query to To check if multi-org is setup
Query To find out details of concurrent request submitted with certain conditions
GL Batches Query
Project Accounting and Purchasing Order Detail Query
Details of Projects closed in particular period query
Form personalization query on form
Segments used in DFF Query
PA Projects Details Query with GL
Query To Find GL Journal Header Summary
Query To Get The Details Which Are Posted To GL Through Payables
Query To Find GL Balances
Query to Find GL Journal Line Based On Trial Balance
Query to Find GL Budget Details Associated with Ledger
Query To find Employee Details in oracle apps
Query To find employee Salary details in oracle apps
Query to get employee Special Information
Query to get Employee Probation and Notice Period
Query to find Employee Tax Info State Tax rules
Query to find Employee tax info and fedral tax rules
Query to find Employee Entries and Element entries
Query to find Employee Absence And Other Info Details
Query to Show The Elements Entries Attached To A Person
Query To Get Employee Payroll Name And Pay Bases
Query To Get Employee Address Details
To Get Receivables Ship To Query
To Get Receivables Bill To Query
Query to Get Open Transactions
Query to Get Drilled-down Transactions
How to find out Apps Instance Login URL from database
Query to Get Unapplied Receipts By Customer
Query to Get Application Details
Query to Get Database Details
Query to Get Value Sets
Query to Get Value Sets Details
Query to Get Database Registry listing database Components in use
Query to Get GL Exchange Rates
Query to Get NLS Parameters
Query to Get DB Parameters
Query to get DBA Directories
Query to get Database Links
Query to Get List of Asset Books by Operating Unit
Query to get Oracle form Details
Query to Get AOL Messages
Query To get workflow Details
Add Concurrent Program to Request Group From Backend
Query to get AP Invoice Audit details
Query to get Customer Name and Address
Query to Get GL Journal Reconciliation Details in Oracle Applications R12
Query to Get AP Invoice Duplicate Audit Details in Oracle Applications
INTERVIEW QUESTIONS
Oracle Interview Questions and Answers
Concurrent Program Questions and Answers
Oracle Workflow Questions and Answers
General Ledger Setup Questions and answers in oracle applications
Oracle SQL interview questions and answers
Oracle PL/SQL interview questions and answers
Oracle Application Interview questions and Answers
Oracle Forms Interview Questions and Answers
Oracle Reports Interview Questions and Answers
Oracle Forms Customization Question and Answers in Oracle Apps
Home
»
SQL
»
SQL Length
Friday, 1 April 2016
SQL Length
Posted by
Dayakar
at
05:00
Labels:
SQL
This will give length of the string.
Syntax: length (string)
Ex:
SQL> select length('computer') from dual;
LENGTH
-----------
8
Share this article
:
0 comments:
Post a Comment
Subscribe to:
Post Comments (Atom)
Popular Posts
Project Accounting and Purchasing Order Detail Query
Query To check Locks on a Table
Query to Get Concurrent Program details in Oracle Apps
Oracle Forms Introduction
Find Application URL From Database in Oracle App R12
Manipulating Data in PL/SQL
Fndload Template for a Data definition Download Upload Command
SQL Introduction
Insert Data into Oracle Table By Using Column Address
Find IP Address and Host Name using PL/SQL
0 comments:
Post a Comment