How can I get column names from a table in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is the syntax of DELETE command?
Explain oracle left join with an example?
How to add another datafile to a tablespace?
In oracle there is column command, how will you explain that?
What is pragma autonomous transaction in oracle?
How to shutdown your 10g xe server from command line?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Display Odd/ Even number of records?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to write a query with a left outer join in oracle?
How to create a new table in your schema?