help this newbie

[swakoo]

i am completely new to these and i had a few qns.
first. i need to update a table using pl/sql developer and oracle8i. how do i know whether my row has being updated?pls give me some code..

next i had to use a select statement to retrieve something from a table and convert it into a 4 digit variable.. for eg the int inside is 23. i had to convert it to 0023.

can any expert pls help?

 

[Daniel Thei]

Hi swakoo,

First question: you can choose the returning clause which you can use with update.
eg:
update table set column = value returning column into :variable.
For more explanation look into SQL-Reference (take a look at: http://www.oracle.com/technology/documentation/oracle8i.html).

Second question: Try: select to_char(column, '0000') from table.

All beginnings are difficult.

Greetings.
Daniel

 

[Robert_G]

@swakoo
You can download the documentation for your Oracle release directly from Oracle.
After that you can let the PLSQLDV build it's index of those files. Then you have a very cool help system simply by pressing F1 if you encounter an error or if you've select some SQL / PL/SQL command.
@daniel
Guten morgen nach Marburg
When converting a number using to_char you've to use the 'fm' or 'fx' prefix in your format string. Otherwise you'll get a leading space.

SELECT to_Char(23, 'fm0000') as ConvertedNumber
FROm   dual

 

[BWendling]

SELECT SUBSTR('0000'||TO_CHAR(23),-4) FROM DUAL

 

[Daniel Thei]

Thank you Robert for your tip. Sense of Life is just to learn !!
Gr

 

[swakoo]

thanks man.. u guys r just great!