Hi all,
In SQL Server 7.0, I can get top 5 records order by date very easy with this syntax:
SELECT TOP 5 column1 FROM table1
WHERE condition1
ORDER BY column2
But in Oracle8, I don't know how to do that. Someone can help me? MCSD BW.
If this is the first time you start database, there are some username and password created by oracle8i:
uid:sys, pwd:change_on_install (sys have authority DBA)
uid:system or internal, pwd:manager
Oracle recommend you change password immediately. MCSD BW.
I recommend order to get MCSD (this is my took):
1. VB Desktop
2. VB Distributed (have 1,2 question about SELECT, INSERT statement)
3. SQL Design and Implement
4. Analyzing Requirement and Solution Architecture (you must good at SQL Design).
MCSD BW.
Hi,
You can use GetChunk and AppendChunk methods of Field object. I don't try with Oracle but I use good with SQL Server and DB2.
After that is 2 subs in VB6 of an my example:
Const conChunkSize = 8192 '2048 increment multiples depending the image sizes
Sub SaveImage(ByVal oImage As...
Go to www.mcsebraindumps.com, enter link 70-029 (list on left screen) and after that get FRODO's dumps. All questions of the real test is in this. Do questions until you understand in through and you will pass.
Good luck!
MCSD BW. BW.
I find that user INTERNAL has password is any. When I run SQL*Plus, I leave password field empty or type any thing, it accept all regardless of SYS's password changed or not. Is it a bug in Oracle 8.1.7??? (I use Oracle 8.1.7 Enterprise Edition for Windows NT download from www.oracle.com) BW.
I installed Oracle 8.1.7 and when I create a database, an user with name "Internal" and password "manager" is ready. How can I change internal's password or delete it.
I tried with: "ALTER USER internal IDENTIFIED BY test" and got an error: "user 'internal'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.