Home » SQL & PL/SQL » SQL & PL/SQL » break command
break command [message #200045] Fri, 27 October 2006 11:41 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
hello all,
after using break on dept_no, i m getting output as-
SURNAME    FIRST_NAME      D_O_B        STUDENT_NO    DEPT_NO       YEAR
---------- --------------- ------------ ---------- ---------- ----------
Monkhouse  Robert Jones    05-23-1967            9          1          1
Hung-Sun   Jimmy Lau       08-11-1969           12                     3
Middleton  Jane P          09-14-1971           13                     3
Patel      Mahesh          12-07-1970            4          2          1
Jones      Gareth P Y      01-24-1970            5                     1
Grimm      Hans Johan      06-21-1971           10                     1
Scott      Gavin T J       02-20-1971            6                     2
Ayton      Phil J M A      07-13-1967            3          3          1
Brown      Joseph P A      04-19-1970            8                     3
Mulla      Farook F U      10-24-1968           14                     2
Duke       Fitzroy         11-26-1970            1          4          2
Al-Essawy  Zaid M A        11-26-1970            2                     2
Gyver      Sue L J V       07-30-1968           11                     2
Baker      Abu-Mia         03-13-1971            7                     1
Layton     Hugh            11-16-1971           15          5          1

15 rows selected.


how can make it OFF(break command)

with regards
ashish Cool

[Updated on: Fri, 27 October 2006 12:27] by Moderator

Report message to a moderator

Re: break command [message #200047 is a reply to message #200045] Fri, 27 October 2006 11:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean, you no more want the BREAK ?
then
sql> clear break
Re: break command [message #200051 is a reply to message #200047] Fri, 27 October 2006 12:21 Go to previous messageGo to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
Thanx Mahesh,
i want the required output.

with regards
ashish
Re: break command [message #200055 is a reply to message #200051] Fri, 27 October 2006 12:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> i want the required output.
What is your required output?
Re: break command [message #200321 is a reply to message #200045] Mon, 30 October 2006 06:08 Go to previous messageGo to next message
ajaybabu.yaleti
Messages: 11
Registered: October 2006
Junior Member
Hi,

Clear Breaks.

Regards,
Ajay
Re: break command [message #200326 is a reply to message #200321] Mon, 30 October 2006 06:23 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ajay, please, PLEASE ./fa/1605/0/ read the whole topic (if it is not a problem) - you've posted - or, should I say - copied previously posted messages in a few topics you've responded recently.

There's no use in it - you've said absolutely nothing new or different to what we already know.

Brian told you so ./fa/1597/0/ here and here. Calm down a little bit; take a break ./fa/450/0/
Re: break command [message #200327 is a reply to message #200326] Mon, 30 October 2006 06:26 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Littlefoot...I've gotten start using some of those smilies.

Thanks for the laugh this morning !!!
Re: break command [message #200328 is a reply to message #200327] Mon, 30 October 2006 06:37 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Good morning, Brian! ./fa/1598/0/ That's why they are here for!
Re: break command [message #200340 is a reply to message #200045] Mon, 30 October 2006 07:05 Go to previous message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
oh ho...
i got the answer from Mahesh Rajendran. Cool

sorry dear for the delay answering..

with regards
Razz ashish
Previous Topic: Datetime format
Next Topic: ORA-13203
Goto Forum:
  


Current Time: Fri Dec 09 09:58:55 CST 2016

Total time taken to generate the page: 0.08042 seconds