i faced this error when trying to connect to oracle database ora 01017 invalid username password logon denied and i checked the username, password and it's correct. any help will be appreciated
Question
Oraask Latest Questions
Question
could you please someone explain briefly What is relational database management system ? OR what is the meaning of RDBMS?
Question
WaqasExplorer
Hi, When i try to connect to oracle 11g from a php application i am getting this error : ORA-12705 invalid or unknown NLS parameter value specified Please help me to solve this issue
Question
Hello Guys, how can i create synonym in oracle ? thanks.
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
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