添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接
相关文章推荐
胆小的领结  ·  海骊 - 成员企业 - ...·  6 月前    · 
欢快的消炎药  ·  LdapErr: ...·  1 年前    · 
rahul,

Connect by cluse for print number(1-10) is best answer.
but one more way of printing 1-10 no is make function and than use it in query.

============CREATE OR REPLACE function ENAGARMITRA.printnum(i in number,endnum in number) return varchar2 as
dtstr varchar2(1000) :='';
begin

for idx in i..endnum
loop

if dtstr is null or dtstr = '' then
dtstr := to_char(idx);
else
dtstr := dtstr || ',' || to_char(idx);
end if;
end loop;
return dtstr;
exception when others then
return null;
end;
/
=====================

select printnum(1,10) from dual;
===================== sandeep,rajiv,

Yes, I agree on that. The use of connect by clause is best.

Jim Irvine,

Yes, I tried the other queries too. And with function, the one more to generate 1-10 number. It can be though, but I enjoy Oracle functions. I just try on other solutions.

rajiv. and I provide the function too. Please check the posted reply. Well Abhay Kumar Singh's solution is the best I would say!!! Minimum it
had made the whole tensions at work evaporated for a while :D. Rahul
didn't state whether he needs the results in one line or in 10 lines.
Usually it is highly discouraging to see once the desired results are in
place, most the requestors never bother to post a thank you message,
which confirms the time spent was useful L Flashback: February 15, 1995: Computer hacker Kevin Mitnick is arrested (Read more HERE.) Security News: • New Qbot malware variant uses fake Adobe installer popup for evasio...

  • Curated Spark! Pro series - 15th February 2024

    Spark! Pro series - 15th February 2024

    Spiceworks Originals

    Today in History: 1950 Disney’s “Cinderella” opens in theaters On February 15, 1950, Walt Disney’s animated feature Cinderella opens in theaters across the United States. The Chicago-born Disney began his career as an advertising cartoonist in Kan...

  • Curated Asus, Dell or Lenovo laptops and computers

    Asus, Dell or Lenovo laptops and computers

    Hardware

    For the last couple of decades I have been buying Fujitsu computers, laptops and servers here in the UK. I have found their reliability to be fantastic. Sadly, Fujitsu are abandoning the European market and after April you will not be able to buy Fujitsu ...

  • Curated Users cannot change password since July 2023

    Users cannot change password since July 2023

    Windows

    Hello all,I just started a new job and am relatively new to IT in general. My current job has had an issue with their domain since July 2023.Essentially, all users have a permanent password only IT can change because if they try, they receive the message ...

  • Curated Snap! -- Cultured Beef-Rice, Sarcasm Detection, Digital Memory, Free ESXi Axed

    Snap! -- Cultured Beef-Rice, Sarcasm Detection, Digital Memory, Free ESXi Axed

    Spiceworks Originals

    Your daily dose of tech news, in brief. Welcome to the Snap! Flashback: February 14, 1946: Unveiling of the ENIAC (Read more HERE.) Security News: • Romantic AI Chatbots Fail the Security and Privacy Test (Read more HERE.) • Ubuntu ...

  •