Search:

hi

iam planning to write 1z0141. can anybody help me suggesting a good reference book

thanks

hi

i have completed sql and pl/sql prog units
first you have to write 1z0007
for that jason couchman book is very good, which gives you complete sylabus of sql

gujjar

I have created a function which takes two IN parameters (lets say x and y) and both are varchar2 type, and retturn value is also varchar2. this function takes two parameter and concatenate string is...

hi,

can anybody suggest me a good book for 1z0141 oracle forms and reports.
if anybody having softcopy can you send me
thanks
gujjar

hi
thanks to innila and smitai. this helped me for the correct answer

hi
here the question is about dependent objects
For dependent objects,lets say program unit A (current schema)references Program unit B(remote side located). this means A is dependent on B. so in...

that means oracle server automatically cannot records dependencies among objects.is it so?

i have created a function which takes two IN parameters(lets say x and y) of varchar2 type,retturn type is varchar2. this function concatenate two parametes and return the values
which 2 are true...

can you explain in brief about this

you have created a procedure DELETETABLE which uses dynamic sql to our remove a table in your schema. you have granted the EXECUTE privilege to a user X on this procedure
when user X executes the...

the creation of which 4 database objects will cause a DDl trigger to fire
1.index
2.cluster
3.package
4.function
5.synonym
6.database link
7.dimentions

which three statements are true about dependent objects
1.invalid objects cannot be described
2.the oracle server automatically records dependencies among objects
3. all schema objects have status...