Dear community,
I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold.
In other words, assuming I have the following data in database.
FIELD1 FIELD2 FIELD3
========= ============== ... (3 Replies)
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Dear All,
I have a requirement where there are applicaions installed in Unix machine that has to update a set of Oracle data base installed in Windows machine, the question I have here is, which protocol alows Unix application to interact with Database in Windows env. and do we require some... (2 Replies)
Hello All,
I'm a complete Unix newbie, and I have been asked to provide a solution for the following opportunity:
Currently there is an Oracle database residing on a Unix box that I need to connect to on a regular basis from another Unix box. Upon connecting I need to hit multiple tables and... (6 Replies)
Secure packet filtering on high-bandwidths fw/rtr for large business tasks. Has anyone tried this concept on openbsd?
The article is posted at www.sysadminmag.com on page 27. January 2002 issue.
I believe Mike has hit upon something that can be applied in the field today and prevent fw... (0 Replies)
MYSQL_FIX_EXTENSI(1) MySQL Database System MYSQL_FIX_EXTENSI(1)NAME
mysql_fix_extensions - normalize table file name extensions
SYNOPSIS
mysql_fix_extensions data_dir
DESCRIPTION
mysql_fix_extensions converts the extensions for MyISAM (or ISAM) table files to their canonical forms. It looks for files with extensions
matching any lettercase variant of .frm, .myd, .myi, .isd, and .ism and renames them to have extensions of .frm, .MYD, .MYI, .ISD, and
.ISM, respectively. This can be useful after transferring the files from a system with case-insensitive file names (such as Windows) to a
system with case-sensitive file names.
Invoke mysql_fix_extensions like this, where data_dir is the path name to the MySQL data directory.
shell> mysql_fix_extensions data_dir
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_FIX_EXTENSI(1)
