Home » RDBMS Server » Server Administration » Sort
Sort [message #373582] Tue, 24 April 2001 12:25 Go to next message
aish
Messages: 44
Registered: March 2001
Member
How does orcale retrives the data that is in what order.
For ex if I say select * from table .

what is the default sort or order by does orcale uses?
Login for oracle? [message #373583 is a reply to message #373582] Tue, 24 April 2001 12:33 Go to previous messageGo to next message
imrsur
Messages: 8
Registered: March 2001
Junior Member
Hi,
I installed the orcale for NT on my m/c.I am not connected to LAN.

What login/pwd do I use.
I tried scott/tiger
and system/tiger did not work .Please help

Thanks in advance
Login for oracle? [message #373584 is a reply to message #373582] Tue, 24 April 2001 12:33 Go to previous messageGo to next message
imrsur
Messages: 8
Registered: March 2001
Junior Member
Hi,
I installed the orcale for NT on my m/c.I am not connected to LAN.

What login/pwd do I use.
I tried scott/tiger
and system/tiger did not work .Please help

Thanks in advance
Login for oracle? [message #373585 is a reply to message #373582] Tue, 24 April 2001 12:33 Go to previous messageGo to next message
imrsur
Messages: 8
Registered: March 2001
Junior Member
Hi,
I installed the orcale for NT on my m/c.I am not connected to LAN.

What login/pwd do I use.
I tried scott/tiger
and system/tiger did not work .Please help

Thanks in advance
Re: Sort [message #373586 is a reply to message #373582] Tue, 24 April 2001 13:29 Go to previous messageGo to next message
Rajiv
Messages: 14
Registered: April 2001
Junior Member
if you use select * from table, then it will select as it appears in the table, with out any sorting.
If you use order by, the default will be ascending. If you want it the other way, use select * from table order by field_name desc
Re: Login for oracle? [message #373587 is a reply to message #373585] Tue, 24 April 2001 13:31 Go to previous messageGo to next message
xxx
Messages: 8
Registered: April 2001
Junior Member
try system/manager
Re: Login for oracle? [message #373588 is a reply to message #373585] Tue, 24 April 2001 13:58 Go to previous messageGo to next message
imrsur
Messages: 8
Registered: March 2001
Junior Member
Sorry I tried both scott/tiger and system/manager
Re: Login for oracle? [message #373589 is a reply to message #373585] Tue, 24 April 2001 14:37 Go to previous messageGo to next message
Rajeev
Messages: 34
Registered: January 2000
Member
Try sys/change_on_install
Re: Sort [message #373602 is a reply to message #373586] Wed, 25 April 2001 21:02 Go to previous messageGo to next message
Arjun V
Messages: 14
Registered: March 2001
Junior Member
If u hv tried all then goto control panel and check if the services for oracle is on...
Services for oracle may be off [message #373603 is a reply to message #373586] Wed, 25 April 2001 21:03 Go to previous messageGo to next message
Arjun V
Messages: 14
Registered: March 2001
Junior Member
If u hv tried all then goto control panel and check if the services for oracle is on...
Re: Login for oracle? [message #373613 is a reply to message #373589] Thu, 26 April 2001 12:31 Go to previous messageGo to next message
imrsur
Messages: 8
Registered: March 2001
Junior Member
Hi Rajeeve ,

I tried sys/change_on_install ,scott/tiger ,system/manager
Did not work .

Now can you claify something.I have installed oracle 8i ,developer (forms 6i).
My OS is windows NT.
I am planning to learn oracle at home .

My first doubt is What is Host stiring (at the login screen).

2. Is it neccessary to connect to server.IF Yes then .What do I connect to when I am home.

3. Cann't I just instal oracle and just start working like other application?

Please help me .

Thanks,
Imrsur
Re: Login for oracle? [message #373615 is a reply to message #373589] Thu, 26 April 2001 13:17 Go to previous message
Rajeev
Messages: 34
Registered: January 2000
Member
1. Host is your machine is which you
have oracle.
Take a look at tnsname.ora and listener.ora
files.

2. You can telnet to server and work.
Server should be configured in such a
way that u can login from a remote location.

3. ?
Previous Topic: How to implement Decode Function in java
Next Topic: Query
Goto Forum:
  


Current Time: Mon Dec 23 10:03:21 CST 2024