Home » SQL & PL/SQL » SQL & PL/SQL » about text
about text [message #210645] Thu, 21 December 2006 11:57 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
hello all!

i want to know about text which gives me insufficient results.
can u please help me.

i have created a view from table. i.e-

SQL> ed
Wrote file afiedt.buf

  1  create view decodeemp1 as(
  2  select
  3  decode(rownum, 1, 'analyst', 2, 'clerk', 3, 'manager', 4, 'supreme')"job",
  4  decode(rownum, 1, rpad(100,8,' '), 2, null, 3, null, 4, 500)"dept_10",
  5  decode(rownum, 1, null, 2, null, 3, rpad(200, 8, ' '), 4, null)"dept_20",
  6  decode(rownum, 1, null, 2, rpad(400, 8, ' '), 3, 100, 4, null)"dept_30",
  7  decode(rownum, 1, 50, 2, null, 3, null, 4, 100)"dept_40"
  8  from emp1
  9* where rownum<=4)
SQL> /
View created.
 


when i query to know the details of text, i failed to-
my query


SQL> SELECT TEXT FROM USER_VIEWS
  2  WHERE VIEW_NAME='DECODEEMP1';
TEXT
--------------------------------------------------------------------------------
(select
decode(rownum, 1, 'analyst', 2, 'clerk', 3, 'manager', 4, 'supreme')"jo
1 row selected


with regards
yas
Re: about text [message #210647 is a reply to message #210645] Thu, 21 December 2006 12:04 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
set trunc off long 8000

Then do your select again.

[Updated on: Thu, 21 December 2006 12:04]

Report message to a moderator

Previous Topic: max(decode) v/c sum(decode)
Next Topic: File In Ftp
Goto Forum:
  


Current Time: Fri Dec 09 11:24:44 CST 2016

Total time taken to generate the page: 0.11565 seconds