oracle sql count number of characters in a field?

Best Answer

You can also use the TRANSLATE function to do this, as follows: SELECT * FROM A_TABLE a WHERE LENGTH(TRANSLATE(a.FIELD, 'x0123456789', 'x')) IS NOT NULL - read more

Second Best Answer

How can I count number of occurrences of the character - in a varchar2 string? Example: select XXX('123-345-566', '-') from dual ... - read more


Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or search documents about how do you transfer songs from our ipod to my son s new mp3 player.




oracle sql count number of characters in a field? community answers



oracle sql count number of characters in a field Similar Questions



oracle sql count number of characters in a field Resources

Specifying the Position of a Data Field. To load data from the datafile, SQL*Loader must know the length and location of the field. To specify the position of a field ... ... read more
Hello Sir, My problem is thru stored procedure or pl/sql annonyms block how to write the records into Excell sheet in Oracle 8i.My collique is doing thru vb.But We ... ... read more
In a first step (before the migration), you shutdown the database an start it again to be sure that all users are disconnected. Now revoke the RESTRICTED ... ... read more
Guidelines First list out the 'processes' parameter from the "init<SID>.ora" file. SEMMNS Sum the number of processes in the "init<SID>.ora ... ... read more
Datetime Literals . Oracle Database supports four datetime datatypes: DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. ... read more
Historically database columns which hold alphanumeric data have been defined using the number of bytes they store. This approach was fine as the number of bytes ... ... read more
SQL Structured Query Language Programming Coding Tutorial Tips, Tricks on Installation, Debugging ... read more
@thatjeffsmith…I have sql developer version 3.1 and want to Import data from Excel(xls) file to an oracle table.the file has 65k records.able to go till last screen ... ... read more
@Rohit, This is not possible using SQL loaders. Because data type of VendorId is numeric and from infile you are getting characters. You have two approches here: ... read more
When building a dynamic sql statement in PL/SQL using native dynamic sql, what would you use for the datatype of the variable storing the statement? ... read more
After setting these up, you will obviously need to manage them. To examine the jobs for audit trail purge, issue: SQL> select * from DBA_AUDIT_MGMT_CLEANUP_JOBS 2 ... ... read more
NAME . DBD::Oracle - Oracle database driver for the DBI module. VERSION . version 1.74. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd ... ... read more