473,549 Members | 2,273 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

My attempt to read the view creation code stored in the Oracle data dictionary has en


My attempt to read the view creation code stored in the Oracle data
dictionary has encountered a problem. The view code appears to be
getting cut off at the end. What have I to do resolve this problem?
--
Posted via http://dbforums.com
Jul 19 '05 #1
2 3742
valexena wrote:

My attempt to read the view creation code stored in the Oracle data
dictionary has encountered a problem. The view code appears to be
getting cut off at the end. What have I to do resolve this problem?

--
Posted via http://dbforums.com


Read the SQL*Plus users guide to determine the correct settings.

(hint: the guide is at http://docs.oracle.com)

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]
Jul 19 '05 #2
Hans Forbrich <fo******@yahoo .net> wrote in message news:<3F******* *******@yahoo.n et>...
valexena wrote:

My attempt to read the view creation code stored in the Oracle data
dictionary has encountered a problem. The view code appears to be
getting cut off at the end. What have I to do resolve this problem?

--
Posted via http://dbforums.com


Read the SQL*Plus users guide to determine the correct settings.

(hint: the guide is at http://docs.oracle.com)


I think Hans could have given you more of a hint. See SET command in
the SQLPlus Guide. Also notice the datatype of the column you are
trying to display.

HTH -- Mark D Powell --
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1636
by: Pekka Niiranen | last post by:
Hi there, I have tree-like dictionary data = {p_name: {p_keyp: {p_cost: }}} which I update by creating nonexisting branches when necessary. If the full branch already exists I update its 'p_unit' -value only if it is greater than the presently stored item. See code below.
15
13242
by: Håkan Persson | last post by:
Hi. I am trying to set up a simple HTTP-server but I have problems reading data that is beeing POSTed. class httpServer(BaseHTTPServer.BaseHTTPRequestHandler): def do_POST(self): input = self.rfile.read() The self.rfile.read() will hang on the
4
40231
by: francis70 | last post by:
Hi, I have these 2 problem? Is there a way in Oracle to read UNCOMMITED data. i.e. in Oracle the normal behaviour is that a user's updates to a table are visible to other users ONLY when the user commits. But in Informix there is this thing called ISOLATION LEVELS. For example by setting the ISOLATION LEVEL to DIRTY READ, a user will...
3
8092
by: valexena | last post by:
Which Oracle dictionary view gives information about the position of a column in a primary key? -- Posted via http://dbforums.com
11
12674
by: Markus Breuer | last post by:
I have a question about oracle commit and transactions. Following scenario: Process A performs a single sql-INSERT into a table and commits the transaction. Then he informs process B (ipc) to read the new date. So process B starts "select ..." but does not get the previously inserted row. The timespan between commit and select is very short....
3
4009
by: aaj | last post by:
SQL SERVER 2000 Hi all This is my first attempt at writing a stored procedure. I have managed to get it working but its unlikely to be the best way of handling the problem. While writing it I found some things that I don't understand so if any one could shed any light it would be much appreciated. I have posted these at the end.
0
683
by: Jerry | last post by:
Below is ALL the code for all the databases... Here's the problem: I callup the aspx file in IE and the form comes up just fine. When I select a person to update, I get the subject error. Aparently, when I select a person, it's not selecting anyone and returning this error. Here's the full error: Description: An unhandled exception...
104
10801
by: Beowulf | last post by:
I have the view below and if I use vwRouteReference as the rowsource for a combo box in an MS Access form or run "SELECT * FROM vwRouteReference" in SQL Query Analyzer, the rows don't come through sorted by Numb. Everything I've read on the web suggests that including the TOP directive should enable ORDERY BY in views. Does someone have an...
2
158
by: valexena | last post by:
My attempt to read the view creation code stored in the Oracle data dictionary has encountered a problem. The view code appears to be getting cut off at the end. What have I to do resolve this problem? -- Posted via http://dbforums.com
0
7548
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7472
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7832
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5391
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5114
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3499
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1965
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1083
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
786
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.