Home » Other » Suggestions & Feedback » Where did the code tags sticky go in pl/sql?
Where did the code tags sticky go in pl/sql? [message #509180] Thu, 26 May 2011 07:06 Go to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
I can't see it anymore and its not been merged into the guide.
Re: Where did the code tags sticky go in pl/sql? [message #509182 is a reply to message #509180] Thu, 26 May 2011 07:19 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yah You are right I just Observed that ...as it was not there all the associated links giving errors.....
Re: Where did the code tags sticky go in pl/sql? [message #509184 is a reply to message #509182] Thu, 26 May 2011 07:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I deleted it by mistake, I already asked Littlefoot to provide it back... if she has a backup.
Unfortunately the site does not have a recycle bin.

Regards
Michel
Re: Where did the code tags sticky go in pl/sql? [message #509185 is a reply to message #509184] Thu, 26 May 2011 07:22 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
oops... /forum/fa/7264/0/

Don`t know whether it is possible or not for little foot to replace it back as earlier ...The following will help us if she does n`t have any backup of it ...

Quote:
How to format your post?

If you are providing code snippets such as SQL*Plus copy/paste, please be sure to use formatting tags:
 Enter your code here.

It makes a huge difference to the forum readers. Unreadable code makes a question harder to understand and will delay answers. A lot of people don't spend that much time on the forum and unclear posts will be skipped more often because they take a lot more time to decipher.

The difference between the code blocks below is clear:

First a block without proper tags, you'll notice that it is not that readable:

DECLARE
CURSOR yourcursor
IS
SELECT yourcolumn
, another_column
FROM yourtable
WHERE some_column BETWEEN A AND B
AND some_other > SYSDATE;
BEGIN
FOR a_record IN yourcursor
LOOP
do_something_here;
IF a_record.another_column = 1
THEN
do_extra_stuff;
ELSE
do_other_stuff;
ELSE;
END LOOP;
END;


Now, the same PL/SQL block this time with use of the code tags. It clearly delineates the code from the other text and preserves text indenting.
DECLARE
CURSOR yourcursor
IS
SELECT yourcolumn
, another_column
FROM yourtable
WHERE some_column BETWEEN A AND B
AND some_other > SYSDATE;
BEGIN
FOR a_record IN yourcursor
LOOP
do_something_here;
IF a_record.another_column = 1
THEN
do_extra_stuff;
ELSE
do_other_stuff;
ELSE;
END LOOP;
END;

You can also paste the code in your message, select it and hit this button .

What if the code is not formatted itself? Code tags will do little about that. So you first have to format the code
by hand
via an external tool (like TOAD)
via the SQL Formatter page of OraFAQ.
Make sure that lines of code do not exceed 80 characters.




I have everything in my mails ...Except images..

When asking for assistance, sometimes you post your own code. In order to make it easier to read, you should use [code] tags. It isn't difficult - take a look!



Now see the difference - code you used to post is on the left, and the same code (the one you are about to post now and in the future) is on the right side:



For much more information, read OraFAQ Forum Guide. /forum/fa/9023/0/
/forum/fa/9024/0/


Sriram

[Updated on: Thu, 26 May 2011 07:44]

Report message to a moderator

Re: Where did the code tags sticky go in pl/sql? [message #509195 is a reply to message #509185] Thu, 26 May 2011 08:08 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Meanwhile I have Updated It Here http://www.orafaq.com/forum/t/171557/136607/
Can I Have Your comments on this.Of course Little foot images are Damn good than My images.Any moderator can delete it ....If they think that is Just Like Garbage.

Sriam
Re: Where did the code tags sticky go in pl/sql? [message #509196 is a reply to message #509195] Thu, 26 May 2011 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for this first step.

Regards
Michel
Re: Where did the code tags sticky go in pl/sql? [message #509252 is a reply to message #509184] Thu, 26 May 2011 11:31 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Michel Cadot wrote on Thu, 26 May 2011 05:21

...I already asked Littlefoot to provide it back... if she has a backup. ...


I always assumed Littlefoot was male, although I don't know why. I see the profile does not say which.
Re: Where did the code tags sticky go in pl/sql? [message #509253 is a reply to message #509252] Thu, 26 May 2011 11:41 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Laughing
Even on here http://www.orafaq.com/forum/mv/msg/170857/506523/136607/#msg_506523


Sriram
Re: Where did the code tags sticky go in pl/sql? [message #509254 is a reply to message #509253] Thu, 26 May 2011 11:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Last time I checked I was male. Next check is scheduled for a year after Monday. Will let you know the results (if someone reminds me).
Re: Where did the code tags sticky go in pl/sql? [message #509257 is a reply to message #509254] Thu, 26 May 2011 12:06 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Laughing
I thought You are Female having "little f`t" .........
..........etc Just kidding.

Sriram
Re: Where did the code tags sticky go in pl/sql? [message #509259 is a reply to message #509254] Thu, 26 May 2011 12:50 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Littlefoot wrote on Thu, 26 May 2011 12:51
Last time I checked I was male. Next check is scheduled for a year after Monday. Will let you know the results (if someone reminds me).



I assumed male. I assume everyone is male except those with obvious female non-alias names. I do not see people's avatars, as I have images blocked.

You should not have said "if someone reminds me" because I can bet you, some geek here (possibly me), will write it down somewhere to remind you in a year. I can almost guarantee someone will do it.
Re: Where did the code tags sticky go in pl/sql? [message #509261 is a reply to message #509259] Thu, 26 May 2011 12:53 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
joy_division wrote on Thu, 26 May 2011 10:50

You should not have said "if someone reminds me" because I can bet you, some geek here (possibly me), will write it down somewhere to remind you in a year. I can almost guarantee someone will do it.


I already put it on my calendar.
Re: Where did the code tags sticky go in pl/sql? [message #509280 is a reply to message #509261] Fri, 27 May 2011 00:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No problem. Just don't expect me to publish the proof in public /forum/fa/917/0/
Re: Where did the code tags sticky go in pl/sql? [message #510264 is a reply to message #509259] Fri, 03 June 2011 05:12 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
joy_division wrote on Thu, 26 May 2011 18:50
I assumed male. I assume everyone is male except those with obvious female non-alias names.


And even then there's no guarantees.

Very few have avatars either way, you're not missing much.
Re: Where did the code tags sticky go in pl/sql? [message #521798 is a reply to message #510264] Fri, 02 September 2011 03:20 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
It's gone again, or the last vestige of my sanity has, one of the two.
Re: Where did the code tags sticky go in pl/sql? [message #521802 is a reply to message #521798] Fri, 02 September 2011 03:56 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's alright, that last vestige is still there.
Anyone got a backup copy?
Re: Where did the code tags sticky go in pl/sql? [message #522023 is a reply to message #521802] Mon, 05 September 2011 11:49 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Its here Now
http://www.orafaq.com/forum/t/174502/136607/

Sriram
Re: Where did the code tags sticky go in pl/sql? [message #522024 is a reply to message #522023] Mon, 05 September 2011 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are 9 hours late! Everyone saw it.

Regards
Michel
Re: Where did the code tags sticky go in pl/sql? [message #522025 is a reply to message #522024] Mon, 05 September 2011 12:17 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And here's a copy if it appears once more:




Please, format your code and - before submitting a message - enclose it into the [code] tags.

/forum/fa/9318/0/

Note the difference; see how the formatted code is easier to read?

/forum/fa/9319/0/


[Updated on: Mon, 05 September 2011 12:17]

Report message to a moderator

Previous Topic: OraFAQ Forum Guide
Next Topic: New "Topic Type" request
Goto Forum:
  


Current Time: Fri Mar 29 06:53:50 CDT 2024