Sql Exferts Ravali

[nenu_devudni]

oka column lo datatype (number 8,3) type undi .. andulo fractions values, interger values unay .. whole number oo kado ela check cheyali seppandi  bye1

[nenu_devudni]

lipt 

[150bryant]

question malli adgu

check cheyadam enti? query and check how the values are

[nenu_devudni]

question malli adgu

oka table .. andulo oka column ..aa column data type = number(8,3) ... 

 

column lo sample values = 1, 0.5, 20, 100 ... ipudu aa col lo values fetching chestuna vuncle .. ipudu aa fetch chesina value .. whole number aa kada adi kanukovali ... ela how ? 

[KharjuraNaidu]

question malli adgu
check cheyadam enti? query and check how the values are

Automate ela ani

[SUbba LIngam]

oka table .. andulo oka column ..aa column data type = number(8,3) ... 

 

column lo sample values = 1, 0.5, 20, 100 ... ipudu aa col lo values fetching chestuna vuncle .. ipudu aa fetch chesina value .. whole number aa kada adi kanukovali ... ela how ? 

 

find decimal point '.' in the field value, if the value doesn't have '.' then its a whole number(i guess assuming there wont be any values like 1.0, 1.00 etc).

[nenu_devudni]

find decimal point '.' in the field value, if the value doesn't have '.' then its a whole number(i guess assuming there wont be any values like 1.0, 1.00 etc).

deni oracle form lo use seyali vuncle .. regexp_like lantivi vadi "." kosam vethikithe .. buthulu thidutundi form ..  bye1

[ronitreddy]

deni oracle form lo use seyali vuncle .. regexp_like lantivi vadi "." kosam vethikithe .. buthulu thidutundi form ..  bye1

REGEX only string fields midane use cheyali ankunta man..

 

Nu chesedi ee field data type?

[SUbba LIngam]

deni oracle form lo use seyali vuncle .. regexp_like lantivi vadi "." kosam vethikithe .. buthulu thidutundi form ..  bye1

 

calling SQL experts then

[ranku_mogudu]

cast it as round of an integer

 

select cast(ROUND (col,0,1) as int) from tablename

[ranku_mogudu]

you can use CEIL or FLOOR Functions too

[Afdb_spider]

Select Case when column_name = round(column_name) then 'whole_number'else 'mod_number' end as ne_good from table_name;

[nenu_devudni]

REGEX only string fields midane use cheyali ankunta man..

 

Nu chesedi ee field data type?

number(8,3)

 

 SELECT 'Y'

     INTO mul

     FROM DUAL

    WHERE REGEXP_LIKE (multiplier, '[._%-]');

 

ela try sesa vuncle .. "." unte .. Y ostadi lekapothe null ostadi ..danitoh i can find out ... but oracle form regexp_like use cheyanivatle ..

[nenu_devudni]

Select Case when column_name = round(column_name) then 'whole_number'else 'mod_number' end as ne_good from table_name;

apude anni whole numbers ee ossay ga vuncle ... nenu whole num ki convert seyatle vuncle ... whole num aa kada ani kanukuntuna .. 

[Afdb_spider]

apude anni whole numbers ee ossay ga vuncle ... nenu whole num ki convert seyatle vuncle ... whole num aa kada ani kanukuntuna ..

Solution sepna ardam seskoleni stage lo unavanmata..jpgif