At the time of installation of oracle 9i, it will prompt you for type of databse selection, which is to be created. At this time you can choose, 'Software only' option instead of database type. So...
Type: Posts; User: jaya_geek; Keyword(s):
At the time of installation of oracle 9i, it will prompt you for type of databse selection, which is to be created. At this time you can choose, 'Software only' option instead of database type. So...
what exactly you want?
hi all
will it work after shutdown of my database? i mean.......one person connected and disconnected to my database.........next i shut it down....and started it up...............still i want his...
hi all
@sirisha
thanx4 reply
your 2 methods shows the current session details means IP address of the machine, if it is connected right now. but i told that.....i want IP address of the machine,...
hi
@krishna
i missread the question actually.......
any way RRRR has very usefull than YYYY in some situations........any one could tell this? i think SQL programers know this concept.
...
hi
Tip of the day thread already exist. that too startrd by u only.....
u can use that na...
Jaya
select * from emp where to_char(dob,'ddmmRRRR')=to_char(sysdate,'ddmmRRRR')
Jaya
hi
Tip of the day::)
to minimize the fragmentations and improve query response time related to one particular table just reorganize the table in the following way:
SQL> alter table <...
hi
suppose one client machine is connected to my oracle server, and after perform 1,2 transactions he is disconnected. how to find his IP address?
If we want to monitor upcoming...
hi
y not we can, can u post the returned error?
Jaya
hi
You are right, when we use cache with sequences, we miss some values bcoz of instance shutdown and 'age out' of shared pool ( which contains the cached sequences ).
here is some trade off....
hi
who said that fedora will not support oracle 10g...
it will work nicely.....
Jaya
i am raising old topics bcoz lack of sufficient new stuff...
hi
STARTUP FORCE
it will just switch off the database as it is ( without checkpoint) and do normal startup.
we can use this method in special cases, like ... if database giving error while...
hi
in any any version of oracle, you can alter sys from system.
i believe you could solve your problem.
Jaya
hi you have to change the shared_pool_size parameter in your init.ora file. It may find in your $ORACLE_HOME/dbs directory.
Jaya
use oracle wrap utility to encrypt your procedures and packages. But can't wrap triggers.
Jaya
hi all
well it's working...thank you susarlasireesha
what i understood is
md %date:~7,2%%date:~4,2%%date:~10,4%
is combination of 3 parts
hi
@susarlasirisha
can you explain your 6 steps...i am unable to understand :confused:why you created date in one file and copy that in another finally call that one. I am confused.
DATE /t...
hi all
some one asked questions, and some others giving solutions. but final result ( problem rectified or not ) is not here. If any one could solved the problem please post that here...then new...
hi
vice versa possible? i mean is possible to import into 9i which is exported from 10g? i never tried...but i think we can't.
Jaya
hi
yaa table level trigger is better. even form level trigger also come to oracle level to do that. oracle trigger is there 2 do that...why do we go for form level again.....i think so.
Jaya
hi all
@jit_mum
harry asked for how to export data from plsql procedures. means how to invoke the process what we do in command prompt ( exp scott/tiger@dba1 file=new.dmp .....like that ) from...
hi you can go for OCA/OCP dumps
which depends on the version of the oracle.
in case 9i
1) Sql/PLSql
2) Fundamentals - 1
3) Fundamentals - 2
4) Performance Tuning
hi all
@susarlasireesha
well, it's ok, but can u explain what is escape and it's use?
we should know the use of quotes with coloum. since we can't create a coloum name with spaces....i...
hi
i think , you are trying to build a C/C++ program to handle a database, right? then
are you expecting only one company? then
just create 2 binary file to handle database, one is for...