Sql Exferts Ravali

[4Vikram]

yes naku ee kastam ochina .. case statement toh ochi help sessadu ... he is the real spider 

spider aa mazaak aa.. spider spides the spide man 

[4Vikram]

batta emana cover ayinda spider maya .. nu sepina solution inka work kale .. form la case pedithe thengay anadi .. aa case thapite inko solution seppav  ru 10+yr exp outside in handling cases

yes handling suit cases lo mast experience adiki .. 

[rajprakashraj]

Select * from table where column not like '%.%';

[Afdb_spider]

batta emana cover ayinda spider maya .. nu sepina solution inka work kale .. form la case pedithe thengay anadi .. aa case thapite inko solution seppav ru 10+yr exp outside in handling cases

Decode?

[Afdb_spider]

Select * from table where column not like '%.%';

.

[nenu_devudni]

i gotted .. tanks all .. appreciate all ur support .. especially spidey thatha 

[nenu_devudni]

yes handling suit cases lo mast experience adiki .. 

[ronitreddy]

 

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 ..

 

Ala work out kaadu mayya..

 

Edo CEILING/FLOOR functions unatayi kaani..avi kuda round off ee chesthayi ankunta whole numbers ki..am not sure..okasari google chey

[nenu_devudni]

Decode?

em le vuncle ... mundu original value ni edsukochi ...  ochina value ni round ga sesi .. original value toh compare sesa ..avnu ante avnu ani kadu ani kadu ani message print sesa .. ma odu gudalu simpukuni .. form worked ur pentastic ani poyadu.. 

[ronitreddy]

em le vuncle ... mundu original value ni edsukochi ...  ochina value ni round ga sesi .. original value toh compare sesa ..avnu ante avnu ani kadu ani kadu ani message print sesa .. ma odu gudalu simpukuni .. form worked ur pentastic ani poyadu.. 

Super machaaa

[KharjuraNaidu]

em le vuncle ... mundu original value ni edsukochi ...  ochina value ni round ga sesi .. original value toh compare sesa ..avnu ante avnu ani kadu ani kadu ani message print sesa .. ma odu gudalu simpukuni .. form worked ur pentastic ani poyadu.. 

aa column ni integer ga convert chesi orginal column to compare cheste telustayi ga

[jaffanajeffada]

SELECT num

  FROM (SELECT 1 AS num FROM DUAL

        UNION

        SELECT 200.05 AS num FROM DUAL

        UNION

        SELECT 200 AS num FROM DUAL

        UNION

        SELECT 300.06 AS num FROM DUAL

        UNION

        SELECT 300 AS num FROM DUAL

        UNION

        SELECT .05 AS num FROM DUAL) a

 WHERE TO_CHAR (num) NOT LIKE '%.%'

[KharjuraNaidu]

Super machaaa

ento devudi ki ee kashtalu    no comment

[nenu_devudni]

aa column ni integer ga convert chesi orginal column to compare cheste telustayi ga

interger ga convert sesudi endi vuncle ... adi already interger value ne .. kakapothe andulo fraction values unay .. original value ni round toh compare sesa anthe .. 

[Afdb_spider]

em le vuncle ... mundu original value ni edsukochi ... ochina value ni round ga sesi .. original value toh compare sesa ..avnu ante avnu ani kadu ani kadu ani message print sesa .. ma odu gudalu simpukuni .. form worked ur pentastic ani poyadu..

Nen sepindhi nake septhunav le..iga po..sallaga oka beer ey..jpgif