You can also try this
right('000000'| |rtrim(cast(<nu mber> as char(6))),6)
This looks good right....
Cheers,
Rahul
frozenmist
Last Activity: Mar 28 '08, 05:33 AM
Joined: May 2 '07
Location: Bangalore
-
REPEAT('0',6-LENGTH(RTRIM(CA ST(xxxxx AS CHAR(6)))))||RT RIM(CAST(xxxxx AS CHAR(6)))...Leave a comment:
-
Hi,
As you have posted this question in the articles section of oracle, I want to move it to its respective forum. Can you please specify which database you are using, so that the thread can be moved to the proper forum and your question can be discussed by the experts there.
Please do not post questions in the articles section.
Thank You
MODERATORLeave a comment:
-
Hi,
Can you please post what error you are getting?Leave a comment:
-
Hi Saii,
Its not a question. Would you be interested in taking up responsibility as an expert?
Please do reply
CheersLeave a comment:
-
Hi,
Try giving
[code=sql]
CREATE PROCEDURE PART6(IN a FLOAT, IN b FLOAT, OUT retval FLOAT)
BEGIN
set retval = a * b;
END
[/code]
Hope it is solved,
Cheers.Leave a comment:
-
Hi,
One reason dbms_output may not be working is that you havent set server output to on...
So give
set serveroutput on;
Hope it helps
CheersLeave a comment:
-
Hi Sush,
You have to give where clause for the condition.
You can also have the query using case, if you dont want to use where...
[code=sql]
select case when empname like 'jack%' then empname end as empname from employess ;
[/code]
Cheers...Leave a comment:
-
Hi,
Please take more care while posting threads. You had posted a duplicate thread, which I have deleted.
Thank you...
Moderator...Leave a comment:
-
I cudnt get my hair nor my eye brows...
Both are very rare specimen... may be because of that...Leave a comment:
-
666 is equal 3
777 is equal 0
888 is equal 6
816 is equal 3
Is this the answer?
No of rounds in the numbers...
Cheers...Leave a comment:
-
Hi,
Please post your code so that we may know where the error is...
CheersLeave a comment:
-
Hi Saii,
How can I contact you? You have disabled PM and email, That is why...Leave a comment:
-
Hi,
Answers in brief:
http://www.oracle.com/technology/ora...ch_tuning.html
This link, just gives a small explanation on your first question
Sql hints are like you are asking the query to do something in a particular way. You specify in the query to use a certain index etc:
eg: select /*+ index(scott.emp ix_emp) */ from scott.emp emp_alias
Cheers...Leave a comment:
-
Hi Santosh,
Please give meaningful titles in future as the experts can view you question easily.
ModeratorLeave a comment:
-
Hi,
Dynamic Sql: Its like you build the query during run time.
For example: suppose you dont know the table name on which you need to query on and you are getting it as input parameter to a procedure. Then you need to build the query as a string and execute it. In short , we know of the outcome of the query only during execution.
eg: set v_string ='Insert into table1 values (1,2)';
execute immediate v_string...Leave a comment:
-
Asking 'Do you have children?'
And when 'yes' is the reply...
Asking 'Are you married?'Leave a comment:
-
hI,
did you give
stl_dr
as connection string?
Please check it and reply.
CheersLeave a comment:
-
Hi Liza,
Do you want to update a row?
Then why dont you use the update query.
Update <tablename> set <ntextcolumn>=< value> where <condition>
If what u meant was something else , please specify.
CheersLeave a comment:
-
Hi,
You cant insert into the view any way because it contains select columns from two tables...
Is this what you meant?
CheersLeave a comment:
No activity results to display
Leave a comment: