SQL QUIZ second phase   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchivesCine Talk - Reviews, Gossips, Insider Info etc.Archive through June 20, 2005 � SQL QUIZ second phase Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Leo2leo
Pilla Bewarse
Username: Leo2leo

Post Number: 61
Registered: 09-2004
Posted From: 210.143.35.12

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 3:13 am:   Edit PostDelete PostView Post/Check IP

//
SQL> SELECT replace('Hello;How are you;I am fine', ';', CHR(10)) "
2 Petrol_bunk" from dual
3 /


Petrol_bunk
---------------------------
Hello
How are you
I am fine


SQL>
//
enti pb arts mayya...nannu etti D'dam ledu kada
Top of pagePrevious messageNext messageBottom of page Link to this message

Gula
Vooriki Bewarse
Username: Gula

Post Number: 3474
Registered: 06-2004
Posted From: 69.109.221.118

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 2:37 am:   Edit PostDelete PostView Post/Check IP

bunk mayya aa oracle tutorial naaku pamputha annavu pampochu kada......
Top of pagePrevious messageNext messageBottom of page Link to this message

Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk

Post Number: 122
Registered: 06-2005
Posted From: 68.164.157.41

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 2:32 am:   Edit PostDelete PostView Post/Check IP

Oka String lo chala strings ";" ( semicolan) seperated to unnayi

Example : "Hello;How are you;I am fine"

aa string in input iste out put lo
Hello
How are you
I am fine

Ani out put raavali. ( ee question ki 3 points )

Already Leo uncle leading with 2 Points:
Top of pagePrevious messageNext messageBottom of page Link to this message

Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk

Post Number: 121
Registered: 06-2005
Posted From: 68.164.157.41

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 2:29 am:   Edit PostDelete PostView Post/Check IP

Good Job inka asalina queries rayinchamantava?
Top of pagePrevious messageNext messageBottom of page Link to this message

Leo2leo
Pilla Bewarse
Username: Leo2leo

Post Number: 60
Registered: 09-2004
Posted From: 210.143.35.15

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 1:34 am:   Edit PostDelete PostView Post/Check IP

//
Chi Waste fellows okkadu kooda answer ivvaledu
//

Cha yedava jivatam...ichchi waste fellow ni ayyanu...
Top of pagePrevious messageNext messageBottom of page Link to this message

Leo2leo
Pilla Bewarse
Username: Leo2leo

Post Number: 59
Registered: 09-2004
Posted From: 210.143.35.18

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 1:22 am:   Edit PostDelete PostView Post/Check IP

//
SQL> ed
Wrote file afiedt.buf

1* SELECT to_char(1934893.45 , '9,999,999.99') from dual
SQL> /

TO_CHAR(19348
-------------
1,934,893.45

SQL> //

deenikenduku mayya anta guddalu(battalu) chinchukuntav...
edo joke ki annale mayya iyyala repu anni serious ayipotunnai

endi Tech only section ki transfer cheyyaledinka ii thread ni...
Top of pagePrevious messageNext messageBottom of page Link to this message

Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk

Post Number: 115
Registered: 06-2005
Posted From: 68.164.157.41

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, June 15, 2005 - 12:48 am:   Edit PostDelete PostView Post/Check IP

Chi Waste fellows okkadu kooda answer ivvaledu
Top of pagePrevious messageNext messageBottom of page Link to this message

Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk

Post Number: 110
Registered: 06-2005
Posted From: 68.164.85.68

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2005 - 11:15 pm:   Edit PostDelete PostView Post/Check IP

Naa previous nick neeku teliyada
Teliyaka povadame better
Top of pagePrevious messageNext messageBottom of page Link to this message

Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk

Post Number: 109
Registered: 06-2005
Posted From: 68.164.85.68

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2005 - 11:14 pm:   Edit PostDelete PostView Post/Check IP

Tondaraga Answer cheyyi leka pote Neeku minus points ista

I am Dataware house designer mama, previously C programmer for Data structures.
Top of pagePrevious messageNext messageBottom of page Link to this message

Chonga
Bewarse
Username: Chonga

Post Number: 2457
Registered: 12-2004
Posted From: 203.101.117.1

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2005 - 11:05 pm:   Edit PostDelete PostView Post/Check IP

bunk mama nee flashbacking emi??
Top of pagePrevious messageNext messageBottom of page Link to this message

Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk

Post Number: 108
Registered: 06-2005
Posted From: 68.164.85.68

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2005 - 11:01 pm:   Edit PostDelete PostView Post/Check IP

I want to display 1934893.45
as 1,934,893.45 ( for this question number of points 2 )

using simple select statement.

This time I will final progress card with points for each person. Rush before HoneyMist mama answer all the questions. He is very fast and super duper hero.