Pablo

South Korea

1d
awarded Popular Question
Dec
13
awarded Teacher
Dec
12
comment Handling -no records found- in Oracle query
Yes, I missed that.. thx
Dec
12
accepted Handling -no records found- in Oracle query
Dec
12
comment Handling -no records found- in Oracle query
Yeah! both works!!! thx
Dec
12
comment Handling -no records found- in Oracle query
Second method gives the same error...
Dec
12
comment Handling -no records found- in Oracle query
The TO_CHAR method gives the following error: ORA-00904: "N/A": invalid identifier
Dec
12
comment Handling -no records found- in Oracle query
@Sylvain Leroux: Apparently no. I was hoping WHERE NOT EXISTS will add it whenever no rows found.
Dec
12
comment Handling -no records found- in Oracle query
@Mihai, I would like N/A to be in string representation, not numerical.
Dec
12
asked Handling -no records found- in Oracle query
Dec
9
awarded Notable Question
Dec
7
comment Accessing joined elements
It works only if I go with below answer. Otherwise of course CELLS table does not know anything about other table fields.
Dec
6
awarded Popular Question
Dec
5
comment Accessing joined elements
Dmitry, thanks and have a good rest :)
Dec
5
accepted Accessing joined elements
Dec
5
comment Accessing joined elements
Then I have Invalid reference to variable 'REC' if I write rec.CELLNUM
Dec
5
comment How to pass query params to procedure?
stackoverflow.com/questions/27320391/accessing-joined-elements
Dec
5
asked Accessing joined elements
Dec
5
accepted How to pass query params to procedure?
Dec
5
comment How to pass query params to procedure?
There is another problem though, for which I will open new question.
1 2 3 4 5