| Sort [message #373582] |
Tue, 24 April 2001 12:25  |
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  |
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 |
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 |
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 |
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: Sort [message #373602 is a reply to message #373586] |
Wed, 25 April 2001 21:02 |
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 |
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 |
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. ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
