473,386 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

nls_database_parameters

Expand|Select|Wrap|Line Numbers
  1. SELECT a.value
  2. INTO l_nls_numchr
  3. FROM nls_database_parameters a
  4. WHERE a.parameter =’NLS_NUMERIC_CHARACTERS’;
i need alternative in DB2 pls help me …………………
Nov 14 '12 #1
0 1642

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Noah | last post by:
The problem I'm having is that whenever a user enters accented characters character into a form field the characters are getting stored as question marks in the database. For example, "façade" (c...
1
by: Caroline | last post by:
I want to export/import a DB from PC1 to PC2 PC 1: ----- SQL> select * from nls_database_parameters; PARAMETER VALUE NLS_CHARACTERSET WE8ISO8859P1 PC 2:...
1
by: Isa Karbstein | last post by:
Hi NG, we are using MS-Access 2002 as a frontend for Oracle Databases versions 8i and 10g. Now I have a problem with the connected tables of the 10g database. In Access all text fields are shown...
6
by: Pete Kane | last post by:
Hi All, anyone know of a way to programatically get the WAN ip address of either a NIC or router ?
0
by: alok | last post by:
i having problem in oracle 9i dataBase------ i want to convert my oracle data to sql 2000.....but i cant convert the hindi data from oracle to sql 2000... means...... i having table in...
13
debasisdas
by: debasisdas | last post by:
This thread contains some useful tips in oracle 9i/10g which the forum members might find useful. I would like to share my knowledge with members by adding some new contents also in days to come. ...
3
by: praveen2gupta | last post by:
Hi, I am using oracle 10g. The charset for the database is iso-8859-1. When I run the following command. select * from nls_database_parameters Output is NLS_CHARACTERSET WE8ISO8859P1 My...
4
by: shaileshkumar | last post by:
hi, my name is shailesh,recently i was asked to find the database details(version,name etc) via a java program. please help me shailesh
8
by: vbie | last post by:
How do I store and retrieve 2byte letter like Japanese character in Oracle SQL? What are the SQL statements? Hope you can help me. vbie
3
by: rhandoo | last post by:
Hi, I am facing the problem in displaying the special characters like ( ` ) GRAVE ACCENT in C# windows Application. I am using oracle as back end. In oracle database table the string contain...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.