Please help me to change user password in oracle apps from database.
Question
Oraask Latest Questions
Question
Hi, We have two separate linux machines each of them running a different database. but those two machines doesn't have static IPs (i.e. they are using DHCP). Can we in somehow move data between these two databases without assigning static IPs ...
Question
Hi, Some of the concurrent managers are not coming up and showing the following error :The actual value of the manager is 0. ERROR "System Hold, Fix Manager before resetting counters". thanks.
Question
albertExplorer
Hi, I faces two ORA error while using SYS.DBMS_ADVANCED_REWRITE this my program and error raised : [code] DECLARE l_src LONG; l_dest LONG; BEGIN l_src := 'select a.empno, a.ename, a.sal, sum(b.sal) ' || 'from emp a, emp b ' || 'WHERE a.sal > b.sal ' || 'OR ' || '( a.sal= b.sal ' || 'and a.rowid ...
Question
Hello , i need to cancel Concurrent Requests in back-end. Thanks,
Question
Question
suppose we have created new directory on database server and give it required privileges like : [code]CREATE OR REPLACE DIRECTORY TEST_DIR AS '/usr/tmp'; GRANT READ, WRITE ON DIRECTORY TEST_DIR TO MYUSER;[/code] Now i want to know if oracle has capable to read and ...
Question
matheoExplorer
which approach is do better performance do bulk insert by using insert from select or Cursor for loop ? for example : [code] DECLARE CURSOR Test_C IS SELECT * FROM test_table1; BEGIN FOR Test_C_REC IN Test_C LOOP INSERT INTO test_table2(col1, col2, col3) VALUES (Test_C.col1, Test_C.col2, Test_C.col3); END LOOP; END; [/code] or a simple select, like: [code] INSERT INTO ...
Question
hello, I need query to get all packages , procedures and functions in my oracle database thanks in advance
Question
suppose I want to find all tables and views that has column name "last_name" for example.