How to convert a date to char in oracle? Give one example.
No Answer is Posted For this Question
Be the First to Post Answer
what are different types of deletes?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
Which is faster join or subquery in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
1.display list of all users from ur data base.what is the query?
How to list all tables in your schema?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
what is primary key and foreign key when and where have to use
Please explain the difference between outer join and inner join? With examples would be appreciable..!
What do you mean by a database transaction & what all tcl statements are available in oracle?