Hi there, Is there any function in SQL or PL/SQL to add space to string value ? for example : this value 'oraask' i need the result to be like this : 'ora ask' thanks in advance.
Question
Oraask Latest Questions
Question
i created a sequence and take the nextval from it but i want to rollback this operation to return to previous next value ? is there any way to achieve this, if so please guide me.
Question
hello guys, please help me to get the po change history for revision details when we compare current po with original po? thanks in advance.
Question
Hi, Oracle : 9.2.0.8.0 We have sequence as below: [code] CREATE SEQUENCE TEST_SEQ START WITH 41554558016 INCREMENT BY 2 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 40 NOORDER; [/code] We have written a procedure to increment the sequence value based on another sequence value by comparing the two values. But when I execute the procedure ...
Question
Hello, Which of these queries is the do better performance NOT IN vs NOT EXISTS? and please give me an clear example if possible. thanks
Question
Question
Hi, I have a task and it's simple : all NULL values of a table should be updated to not null let say to be 'Value', however the NOT NULL values will remain the same as it is. consider that the table ...
Question
Hi, Please i am trying to use dbms_assert package in a SQL statement and I want to understand exactly how dbms_assert protects against SQL injection ? thanks.
Question
Hi, I have set of values and I want to order by as follows : we scan left to right . for example for values like '25 AB' ,'30 MT'. 25 comes before 30. [code] create table test_table(COL1 varchar2(240)); insert into test_table values ('50000'); insert into test_table ...
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 ...