Hello Guys, how can i create synonym in oracle ? thanks.
Question
Oraask Latest Questions
Question
when i am trying to use utl_file.fopen it gave me an error ORA-29280: utl_file.fopen invalid directory path error and this what i did: [code] CREATE DIRECTORY mydir AS 'C:\New'; [/code] [code] GRANT READ ON DIRECTORY mydir TO myuser; [/code] then using [code] v_FileHandle := UTL_File.FOpen('mydir', 'myfile', 'w', 32767); [/code] and this the final ...
Question
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
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
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
How to Create the TKPROF Trace File in oracle ?
Question
How to check Archive log sequence in Oracle DB 11g?
Question
How to kill current session in Oracle (ORA-00027 ) ?
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